Filter interviews by
I applied via Naukri.com and was interviewed in Aug 2022. There were 3 interview rounds.
C programming was there in interview
A pointer is a variable that stores the memory address of another variable in C programming language.
Pointers are used to manipulate memory and create dynamic data structures.
They can be used to pass values between functions efficiently.
Pointers can be used to access array elements and structures.
Pointer arithmetic can be used to iterate over arrays and manipulate memory.
Null pointers are used to indicate that a pointe
Top trending discussions
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
Find the first non-repeating character in a string.
Create a hash table to store the frequency of each character in the string.
Iterate through the string and check the frequency of each character.
Return the first character with a frequency of 1.
Connection pooling is a technique of reusing database connections to improve performance.
Connection pooling helps to reduce the overhead of creating and destroying database connections.
It maintains a pool of connections that can be reused by multiple clients.
Connection pooling is commonly used in web applications to handle multiple requests simultaneously.
It can be configured with parameters like maximum number of conn...
A singleton class in PHP is a class that can only be instantiated once.
Create a private constructor to prevent direct instantiation
Create a private static variable to hold the instance of the class
Create a public static method to get the instance of the class
Ensure that the public static method always returns the same instance
To connect to MySQL database using PHP, create a Connection class.
Use mysqli_connect() function to establish a connection
Pass the database credentials as parameters to the function
Create a constructor method to initialize the connection
Create a query method to execute SQL queries
Close the connection using mysqli_close() method
There are three types of errors in PHP: syntax errors, runtime errors, and logical errors.
Syntax errors occur when the code is not written correctly, such as missing semicolons or parentheses.
Runtime errors occur during the execution of the code, such as trying to access an undefined variable.
Logical errors occur when the code runs without errors, but produces unexpected results, such as a miscalculation in a formula.
Session in PHP allows to store user data on the server for later use.
Session starts when a user logs in and ends when the user logs out or the session expires.
Session data is stored on the server and identified by a unique session ID.
Session variables can be set and accessed using the $_SESSION superglobal array.
Session can be destroyed using the session_destroy() function.
Session can be used to store user-specific dat...
Find missing element in an array of elements from 0 to n-1
Calculate sum of all elements in array and subtract from sum of n natural numbers
Use XOR operation on all elements and n natural numbers
Sort the array and find the missing element
I was interviewed before Jan 2021.
Round duration - 60 minutes
Round difficulty - Easy
This was a written coding test with 2 coding questions to be solved in 60 minutes.
You have a sequence of consecutive nonnegative integers. By appending all integers end-to-end, you formed a string S
without any separators. During this pro...
Given a string of consecutive nonnegative integers with one missing number, find the missing integer.
Iterate through the string to find the missing number by checking the consecutive integers.
If there is more than one missing number, all integers are present, or the string is invalid, return -1.
Handle cases where the missing number is at the beginning or end of the sequence.
Consider edge cases such as single-digit numb
You are given a string consisting of English alphabet characters. Your task is to identify and return the first character in the string that does not repeat...
The task is to find the first non-repeating character in a string, or return the first character if all characters repeat.
Iterate through the string to count the frequency of each character
Find the first character with a frequency of 1, or return the first character if no such character exists
Handle both uppercase and lowercase characters separately
Use a hashmap to store character frequencies efficiently
Round duration - 60 minutes
Round difficulty - Medium
Technical interview round with questions around PHP and DBMS.
Connection pooling is a technique used to manage a pool of database connections to improve performance and efficiency.
Connection pooling reduces the overhead of opening and closing database connections for each request.
It allows multiple clients to reuse a pre-established set of connections to the database.
Connection pooling helps in improving the scalability and performance of applications by efficiently managing data...
To create a singleton design pattern in PHP 5, use a private static variable to store the instance and a static method to retrieve it.
Create a private static variable to store the instance of the class.
Create a private constructor to prevent outside instantiation of the class.
Create a static method to check if an instance already exists and return it, or create a new instance if it doesn't.
Yes, PHP can be used to connect to MySQL by using MySQLi or PDO extensions.
Use MySQLi extension to connect PHP to MySQL
Use PDO extension to connect PHP to MySQL
Example using MySQLi: $conn = new mysqli($servername, $username, $password, $dbname);
Example using PDO: $conn = new PDO('mysql:host=$servername;dbname=$dbname', $username, $password);
Different types of errors in PHP include syntax errors, runtime errors, and logical errors.
Syntax errors: Occur when there is a mistake in the code syntax, preventing the script from running.
Runtime errors: Happen during script execution, such as division by zero or calling a function that does not exist.
Logical errors: Difficult to detect as the code runs without errors, but produces incorrect results.
Fatal errors: St...
Session management in PHP involves storing user data on the server to maintain state between multiple requests.
Sessions are started using session_start() function in PHP.
Session data is stored on the server and a unique session ID is sent to the client's browser.
Session variables can be set, accessed, and unset using $_SESSION superglobal array.
Sessions can be destroyed using session_destroy() function.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I was interviewed before Jan 2021.
Round duration - 60 minutes
Round difficulty - Medium
Technical round where the interviewer asked me questions based on data structures , algorithms and load balancer and session management.
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Find pairs of elements in an array that sum up to a given value, sorted in a specific order.
Iterate through the array and use a hashmap to store the difference between the target sum and each element.
Check if the difference exists in the hashmap, if so, add the pair to the result list.
Sort the result list based on the criteria mentioned in the problem statement.
Find the next smallest palindrome strictly greater than a given number 'N' represented as a string 'S'.
You are given a number in string format, a...
Find the next smallest palindrome greater than a given number represented as a string.
Convert the string number to an integer for comparison.
Increment the number until a palindrome greater than the input is found.
Handle cases where the input is already a palindrome or has leading zeros.
Return the next greater palindrome as a string.
Round duration - 60 minutes
Round difficulty - Medium
Technical round where the interviewer asked me questions based on data structures , design patterns and php.
Given a singly linked list of integers, determine if the linked list is a palindrome.
A linked list is considered a palindrome if it reads the same forwar...
Check if a given singly linked list of integers is a palindrome.
Create a function to reverse the linked list.
Use slow and fast pointers to find the middle of the linked list.
Compare the first half of the linked list with the reversed second half to determine if it's a palindrome.
Singleton Design pattern ensures a class has only one instance and provides a global point of access to it.
Ensure the class has a private static instance variable.
Provide a public static method to access the instance.
Make the constructor private to prevent instantiation from outside the class.
Lazy initialization can be used to create the instance only when needed.
Thread safety considerations may be necessary in a multi
Round duration - 60 minutes
Round difficulty - Medium
Technical round where the interviewer asked me questions based on Javascript, dbms, oops concepts and php.
A stored procedure to join two tables in a database.
Use the JOIN keyword to combine rows from two or more tables based on a related column between them.
Specify the columns to be selected from each table in the SELECT statement.
Use the ON keyword to specify the join condition.
Consider using INNER JOIN, LEFT JOIN, RIGHT JOIN, or FULL JOIN based on the desired result.
Test the stored procedure with sample data to ensure it
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
Abstract class can have constructors, fields, and methods, while interface cannot have any implementation.
A class can only extend one abstract class, but can implement multiple interfaces.
Abstract classes are used to define common characteristics among subclasses, while interfaces are used to define a contract...
Use jQuery to extract domain name from a URL
Use the 'a' element to create a temporary link with the URL
Access the 'hostname' property of the link to get the domain name
Use regular expressions to extract the domain name from the URL
Closures in JavaScript are functions that have access to variables from their outer scope even after the outer function has finished executing.
Closures allow functions to access variables from their parent function even after the parent function has finished executing.
They are created whenever a function is defined within another function.
Closures are commonly used to create private variables and functions in JavaScrip...
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I was interviewed before Jan 2021.
Round duration - 60 minutes
Round difficulty - Easy
This was a coding test where we had to solve 2 coding questions in 60 minutes.
Imagine you are Harshad Mehta's friend, and you have been given the stock prices of a particular company for the next 'N' days. You can perform up to two buy-and-sell ...
The task is to determine the maximum profit that can be achieved by performing up to two buy-and-sell transactions on a given set of stock prices.
Iterate through the array of stock prices to find the maximum profit that can be achieved by buying and selling stocks.
Keep track of the maximum profit that can be obtained by performing up to two transactions.
Consider all possible combinations of buying and selling stocks to...
You are provided with a string 'STR'
that consists of lowercase English letters ranging from 'a' to 'z'. Your task is to determine all non-empty possible subsequen...
Generate all possible subsequences of a given string.
Use recursion to generate all possible subsequences by including or excluding each character in the string.
Maintain a current index to keep track of the characters being considered.
Append the current character to each subsequence generated so far.
Recursively call the function with the next index to include the next character in subsequences.
Round duration - 60 minutes
Round difficulty - Easy
This was a technical round where the interviewer asked me questions related to OS and Java.
The critical section problem is a synchronization issue in concurrent programming where multiple processes access shared resources.
Critical section is a code segment that accesses shared resources and must be executed by only one process at a time.
The goal is to prevent race conditions and ensure mutual exclusion.
Solutions include using locks, semaphores, and mutex to control access to critical sections.
Example: Multip...
A thread in Java can be created by extending the Thread class or implementing the Runnable interface.
Extend the Thread class and override the run() method
Implement the Runnable interface and provide the implementation for the run() method
Start the thread using the start() method
Round duration - 30 minutes
Round difficulty - Easy
Typical HR round with behavioral questions.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
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 ...
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...
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 ...
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
I was interviewed before Jul 2016.
I want to join Croma because of its reputation and growth opportunities. To sell Croma brand and others, I will focus on understanding customer needs and providing personalized solutions.
Croma has a strong brand reputation and is a leader in the electronics retail industry
I am excited about the growth opportunities and potential for career advancement at Croma
To sell Croma brand and others, I will focus on building rel...
I have a Bachelor's degree in Business Administration with a focus on Marketing.
Bachelor's degree in Business Administration
Focus on Marketing
Relevant coursework in sales and marketing strategies
Internship experience in sales and customer relations
I am currently staying in New York City.
I am currently residing in the heart of Manhattan.
I have been living in New York City for the past two years.
I enjoy the vibrant culture and opportunities that the city offers.
I applied via Instagram and was interviewed before Sep 2020. There was 1 interview round.
based on 191 reviews
Rating in categories
Sales Executive
16
salaries
| ₹0 L/yr - ₹0 L/yr |
Mobile Technician
11
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Accounts Executive
11
salaries
| ₹0 L/yr - ₹0 L/yr |
Area Sales Manager
10
salaries
| ₹0 L/yr - ₹0 L/yr |
Chip Level Engineer
9
salaries
| ₹0 L/yr - ₹0 L/yr |
Cashify
Quikr
OLX
Croma