Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2021. There were 3 interview rounds.
Create a Rest API for coding assessment
Choose a programming language and framework
Define endpoints and HTTP methods
Implement CRUD operations
Use authentication and authorization
Test API using tools like Postman
Pagination can be achieved by limiting the number of records displayed per page and using page numbers.
Limit the number of records displayed per page to improve performance
Use page numbers to navigate through the records
Implement caching to reduce database queries
Consider using lazy loading to improve performance
Use a server-side framework that supports pagination
Consider using a search feature to filter records
HAVING is used to filter results after grouping, WHERE is used to filter results before grouping.
HAVING is used with GROUP BY clause, WHERE is used with SELECT clause
HAVING filters groups based on aggregate functions, WHERE filters rows based on column values
HAVING is slower than WHERE as it operates on grouped data
Example: SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 5;
Example: SELE...
Creating an index in MySQL improves query performance by allowing faster data retrieval.
Use the CREATE INDEX statement to create an index. Example: CREATE INDEX idx_name ON table_name(column_name);
Indexes can be unique, ensuring no duplicate values. Example: CREATE UNIQUE INDEX idx_unique ON table_name(column_name);
Composite indexes can be created on multiple columns. Example: CREATE INDEX idx_composite ON table_name(c...
Polymorphism in interfaces allows objects to be treated as instances of their parent type, enhancing flexibility and code reusability.
Polymorphism enables methods to do different things based on the object it is acting upon.
Example: An interface 'Animal' with a method 'makeSound()'. Classes 'Dog' and 'Cat' implement this interface with different sounds.
It promotes code reusability and cleaner code by allowing the same ...
Top trending discussions
posted on 30 Aug 2016
I applied via Campus Placement
To find the 3rd highest salary, we can use SQL queries to retrieve distinct salary values and order them.
Use SQL query: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
This query selects distinct salaries, orders them in descending order, and skips the first two to get the third highest.
Ensure the table has enough distinct salaries; otherwise, the query may return NULL.
I appeared for an interview before Sep 2020.
Round duration - 90 mins
Round difficulty - Hard
There were questions related to DP and DFS.
You are given a long type array/list ARR
of size N
, representing an elevation map. The value ARR[i]
denotes the elevation of the ith
bar. Your task is to determine th...
Calculate the total amount of rainwater that can be trapped between given elevations in an array.
Iterate through the array and calculate the maximum height on the left and right of each bar.
Calculate the amount of water that can be trapped at each bar by taking the minimum of the maximum heights on the left and right.
Sum up the trapped water at each bar to get the total trapped water for the entire array.
Round duration - 60 mins
Round difficulty - Medium
At first, I was asked about the different projects that I have done so far. We had a detailed discussion on the same.
He also checked my OOP concepts
Designing an LRU Cache involves implementing a data structure that stores a fixed number of items and removes the least recently used item when full.
Start by defining the data structure for the cache, typically using a combination of a hashmap and a doubly linked list.
Implement methods for getting and setting key-value pairs in the cache.
When a new item is added to the cache, check if it exceeds the maximum capacity. I...
Given a Singly Linked List of integers, your task is to reverse the Linked List by altering the links between the nodes.
The first line of input is an intege...
Reverse a singly linked list by altering the links between nodes.
Iterate through the linked list and reverse the links between nodes
Use three pointers to keep track of the current, previous, and next nodes
Update the links between nodes to reverse the list
Return the head of the reversed linked list
You are given the head node of a singly linked list. Your task is to return a pointer pointing to the middle of the linked list.
If there is an odd number of elements, return the ...
Return the middle element of a singly linked list, or the one farther from the head if there are even elements.
Traverse the linked list with two pointers, one moving twice as fast as the other
When the fast pointer reaches the end, the slow pointer will be at the middle
If there are even elements, return the one that is farther from the head node
Handle edge cases like linked list of size 1 or empty list
Round duration - 60 mins
Round difficulty - Medium
It is HR + Technical round
asked about the Behavioural questions and how you justify yourself in an argument .questions related to current technology.
They gave me feedback on how well I had performed so far and gave me suggestions on what more can I do to further improve myself.
Tip 1 : Be thorough about your projects
Tip 2 : Prepare Ds and Algo and Practice all standard questions
Tip 3 : Know the complexities of the code that you’ve written.
Tip 1 : Mention at least 2 projects.
Tip 2 : Don't make any silly spelling mistakes on resume
Basic DSA and android questions
Live coding round for android
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
Concurrency is the ability of a system to execute multiple tasks simultaneously.
Concurrency allows multiple tasks to run concurrently, improving performance and efficiency.
Concurrency can be achieved through multithreading or multiprocessing.
Example: A web server handling multiple requests simultaneously using multithreading.
ACID principles are a set of properties that guarantee database transactions are processed reliably.
Atomicity: Transactions are all or nothing. If one part of the transaction fails, the entire transaction is rolled back.
Consistency: Transactions bring the database from one valid state to another. All constraints are satisfied.
Isolation: Transactions are isolated from each other until they are completed.
Durability: Once...
I applied via Referral and was interviewed in Jan 2024. There were 3 interview rounds.
Alert notification and logging system
Snakes and Ladder problem
2-3 coding questions were asked - from easy -> medium -> hard level. 1st and 2nd questions were around dynamic programming. Couldn't reach till third question since 1st two questions took time.
I applied via LinkedIn and was interviewed in Sep 2023. There were 2 interview rounds.
TODO task tracking application to manage tasks and deadlines
Create a user-friendly interface for adding, editing, and deleting tasks
Implement a feature to set deadlines and reminders for tasks
Include categories or tags to organize tasks efficiently
Allow users to mark tasks as completed and track progress
Provide a search functionality to easily find specific tasks
I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.
Design splitwise - Low level machine coding round
I applied via Instahyre and was interviewed in Nov 2023. There were 3 interview rounds.
There were one medium and one easy coding question of DSA one of the array and another of string.
Operations Executive
190
salaries
| ₹1 L/yr - ₹3 L/yr |
Quality Analyst
18
salaries
| ₹1.8 L/yr - ₹3.8 L/yr |
Senior Software Engineer
13
salaries
| ₹7 L/yr - ₹19.2 L/yr |
Team Lead
12
salaries
| ₹2 L/yr - ₹3.4 L/yr |
Assistant Manager
8
salaries
| ₹3.2 L/yr - ₹6 L/yr |
PhonePe
KFintech
Razorpay
Rupeek