Yaantra Software Engineer Interview Questions and Answers

Indexes in MySQL are used to improve query performance by allowing faster data retrieval.

• Indexes are created on one or more columns of a table.

• They work by creating a separate data structure that allows for faster data retrieval.

• Indexes can be created using the CREATE INDEX statement.

• Indexes can also be dropped using the DROP INDEX statement.

• Indexes can be used to speed up SELECT, UPDATE, and DELETE statements.

• Indexes ...read more

include_once and require_once are PHP functions used to include files. The difference is in how they handle errors.

• include_once will only include the file once, and will not throw a fatal error if the file is not found

• require_once will also only include the file once, but will throw a fatal error if the file is not found

• Both functions are used to include files that contain functions or variables that are needed in the

Sessions and cookies are both used for maintaining user state, but sessions are server-side and cookies are client-side.

• Sessions store user data on the server, while cookies store data on the client's browser

• Sessions are more secure than cookies because the data is not accessible to the client

• Cookies can be used for tracking user behavior and preferences

• Sessions are typically used for authentication and authorization p...read more

To find missing number in an array of first n numbers.

• Calculate the sum of first n numbers using formula n*(n+1)/2

• Calculate the sum of given array using loop

• Subtract the sum of array from sum of first n numbers to get the missing number

Design a database schema for a chat application with individual and group messaging.

• Create a 'users' table with unique user IDs

• Create a 'messages' table with message IDs, sender and receiver IDs, message content, and timestamp

• Create a 'groups' table with unique group IDs and group names

• Create a 'group_members' table with group ID and user ID to track group membership

• Use foreign keys to link tables together

• Consider inde

SQL query to retrieve all unread messages upon user sign in

• Use a JOIN statement to combine the messages and user tables

• Filter the results to only show messages that have not been read by the user

• Use the user's sign in information to identify which messages are unread

I am excited to join OLX because of its innovative approach to online marketplaces and its commitment to customer satisfaction.

• I am impressed by OLX's user-friendly platform and its ability to connect buyers and sellers from all over the world.

• I am excited to work with a team of talented developers who are passionate about creating cutting-edge technology.

• I believe that OLX's focus on customer satisfaction aligns with ...read more

I have faced difficulties in debugging complex code and managing project timelines.

• Debugging complex code with multiple dependencies

• Managing project timelines with changing requirements

• Working with legacy code and outdated technologies

• Collaborating with team members in different time zones

• Dealing with unexpected bugs and errors

I report to the Technical Lead and am part of the development team.

• I report to the Technical Lead

• I am part of the development team

Our website receives an average of 10,000 unique visitors per day.

• Our website has a steady flow of traffic with a consistent number of unique visitors per day.

• We use Google Analytics to track our web traffic and analyze user behavior.

• Our peak traffic times are during weekdays from 9am to 5pm.

• We have noticed an increase in mobile traffic over the past year.

• Our website's traffic is primarily driven by organic search and

Find pair of elements in an array whose sum is equal to a given number K.

• Iterate through the array and for each element, check if K minus the element exists in the array.

• Use a hash table to store the elements and their indices for faster lookup.

• If multiple pairs exist, return any one of them.

• If no pair exists, return null or an appropriate message.

Session is maintained using session affinity or sticky sessions.

• Session affinity ensures that a user's session is always directed to the same server.

• Load balancer uses a unique identifier to route requests to the same server.

• Sticky sessions can be implemented using cookies or URL rewriting.

• Session replication can also be used to maintain session data across multiple servers.

Singleton pattern ensures only one instance of a class is created and provides a global point of access to it.

• Create a private constructor to prevent direct instantiation of the class

• Create a private static instance of the class

• Create a public static method to access the instance

• Ensure thread safety by using synchronized keyword or static initialization block

• Examples: Logger, Configuration Manager, Database Connection

Explaining abstract class, interface and multiple inheritance in PHP.

• Abstract class is a class that cannot be instantiated and can have abstract methods.

• Interface is a collection of abstract methods and constants that can be implemented by a class.

• Multiple inheritance is not possible in PHP, but can be achieved using interfaces.

• Interfaces can be implemented by multiple classes, allowing for multiple inheritance-like be

Write a stored procedure from given tables and conditions

• Identify the tables and their relationships

• Determine the conditions to be used in the stored procedure

• Write the SQL code for the stored procedure

• Test the stored procedure to ensure it returns the desired results

To increase PHP memory at run time, modify the php.ini file or use ini_set() function.

• Edit the memory_limit value in php.ini file

• Use ini_set('memory_limit', '256M') function to increase memory limit at run time

• Check for memory leaks in the code

• Use unset() function to free up memory after use

php.ini is a configuration file for PHP that allows users to customize various settings.

• Change PHP settings such as memory limit, file upload size, and error reporting

• Enable or disable extensions and modules

• Set timezone and language settings

• Configure email settings

• Control caching and session settings

Use window.location to get domain from a url in jQuery.

• Use window.location to get the full url

• Use .hostname to get the domain name

• Use .replace() to remove 'www.' if present

WAP to find smallest palindrome number larger than given number.

• Convert the given number to string and check if it is already a palindrome.

• If not, increment the number and check if it is a palindrome.

• Repeat until a palindrome number larger than the given number is found.

• Use a while loop to implement the above steps.

WAP to check if linked list elements is a palindrome without using any extra space.

• Traverse the linked list and reverse the second half of the list

• Compare the first half with the reversed second half

• Use two pointers to traverse the list, one at normal speed and other at double speed