Filter interviews by
I applied via Referral and was interviewed before May 2023. There were 2 interview rounds.
To resolve space issue with GET API request, consider pagination, compression, caching, and optimizing query parameters.
Implement pagination to limit the number of results returned in each request.
Use compression techniques like Gzip to reduce the size of the response data.
Implement caching mechanisms to store frequently accessed data and reduce the number of requests.
Optimize query parameters to only request necessary
Top trending discussions
posted on 13 Jun 2024
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
The task was a Codility type
Easy problem on java
I applied via LinkedIn and was interviewed in Sep 2020. There was 1 interview round.
I applied via Recruitment Consulltant
A mutex is a synchronization primitive that ensures only one thread can access a resource at a time.
Create a mutex object using the appropriate library or language-specific function.
Lock the mutex before accessing the shared resource to prevent other threads from accessing it.
Unlock the mutex after finishing the operation on the shared resource to allow other threads to access it.
Example: pthread_mutex_t mutex; pthread...
Identify memory leak in code
Check for any dynamically allocated memory that is not being freed
Look for any infinite loops or recursive functions that consume memory
Use memory profiling tools like Valgrind to detect leaks
Check for any global variables that are not properly managed
I was interviewed before Mar 2021.
To check if a number is a power of 2, we can use bitwise operations.
A power of 2 has only one bit set to 1, so we can use the bitwise AND operator to check if the number is a power of 2.
If n is a power of 2, then n & (n-1) will be 0.
For example, 8 (1000 in binary) is a power of 2, and 8 & 7 (0111 in binary) is 0.
Sort a stack without using another data structure
Use recursion to pop the top element and insert it at the bottom of the remaining stack
Repeat until the stack is sorted in ascending order
Time complexity: O(n^2), space complexity: O(n) due to recursion
Check if array has continuous increasing and decreasing values
Loop through the array and check if each element is greater than the previous one
Once you find the maximum element, check if the remaining elements are in decreasing order
If yes, return true else false
Design a cricinfo (LLD)
Identify the entities: players, teams, matches, scorecards, tournaments, etc.
Define the relationships between entities
Create a database schema to store the data
Implement APIs to fetch and update data
Design a UI to display the information
Consider scalability and performance
Ensure data security and privacy
I applied via Company Website and was interviewed in May 2022. There were 2 interview rounds.
Logical reasoning And aptitude test
C++, python and Java programming
I applied via Referral and was interviewed before Aug 2022. There were 3 interview rounds.
Yes, aggregate functions can be used with HAVING and WHERE clauses. WHERE filters rows before grouping, HAVING filters groups after grouping.
Aggregate functions can be used with HAVING clause to filter groups based on the result of the aggregate function.
Aggregate functions can also be used with WHERE clause to filter rows before grouping.
WHERE clause filters rows before grouping, while HAVING clause filters groups aft...
The order of execution of a SQL query is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
FROM: Specifies the tables involved in the query
WHERE: Filters the rows based on specified conditions
GROUP BY: Groups the rows that have the same values into summary rows
HAVING: Filters the groups based on specified conditions
SELECT: Selects the columns to be displayed in the result set
ORDER BY: Sorts the result set based on speci
User Defined Functions, Stored Procedures, and Triggers are database objects used to perform specific tasks in database management systems.
User Defined Functions are custom functions created by users to perform specific calculations or operations in a database.
Stored Procedures are precompiled SQL statements that can be executed by calling the procedure name.
Triggers are special types of stored procedures that are auto...
I applied via Campus Placement and was interviewed before Sep 2023. There were 2 interview rounds.
Some advanced linked list questions
based on 1 interview
Interview experience
based on 28 reviews
Rating in categories
Customer Success Engineer
9
salaries
| ₹0 L/yr - ₹0 L/yr |
Sales Engineer
8
salaries
| ₹0 L/yr - ₹0 L/yr |
Regional Accounts Manager
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Account Manager
6
salaries
| ₹0 L/yr - ₹0 L/yr |
Customer Service Manager
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Gen
McAfee
Kaspersky Lab
Palo Alto Networks