Filter interviews by
Clear (1)
I applied via Naukri.com
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
Use SQL query with ORDER BY and LIMIT to find the nth highest salary of an employee.
Use ORDER BY clause to sort salaries in descending order
Use LIMIT to specify the nth highest salary
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT n-1, 1
Types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN: Returns rows when there is at least one match in both tables.
LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table.
FULL JOIN: Returns rows when there is a match in one of the tables.
BinarySearch algorithm using Recursion finds the target element in a sorted array by dividing the array in half at each step.
Divide the array in half and compare the target element with the middle element
If the target element is smaller, search the left half recursively
If the target element is larger, search the right half recursively
Repeat until the target element is found or the array is empty
Check if string s is a subsequence of string t.
Iterate through both strings using two pointers.
Compare characters of s and t, moving pointer in t only if characters match.
If all characters of s are found in t in order, return true.
Example: s = 'abc', t = 'ahbgdc' => true
Top trending discussions
I applied via Naukri.com and was interviewed before Mar 2021. There were 3 interview rounds.
Was asked data structure and program logic. scenario based questions were there.
Shortest path can be found using algorithms like Dijkstra's, A* or BFS.
Dijkstra's algorithm finds shortest path in weighted graphs
A* algorithm is an extension of Dijkstra's algorithm and uses heuristics to guide search
BFS can be used to find shortest path in unweighted graphs
All three algorithms require a graph representation and a starting and ending node
I applied via Naukri.com and was interviewed before May 2020. There were 4 interview rounds.
Swapping two numbers without using a third variable
Use arithmetic operations to swap the values
Add the two numbers and store the result in the first variable
Subtract the second number from the result and store it in the second variable
Subtract the second variable from the first variable to get the original value of the second variable
Hackerrank test in Java and Angular
60 min covered all reasoning topics
Coding test according to language
posted on 14 Jun 2024
Reading messages from Google Cloud Pub/Sub involves creating a subscription and pulling messages from the subscription.
Create a subscription to a Google Cloud Pub/Sub topic
Use the subscription to pull messages from the topic
Process the messages received from the subscription
posted on 6 Oct 2022
I applied via Referral and was interviewed before Oct 2021. There were 3 interview rounds.
CFA and DFA are Change-Tracking and Database-First Approaches in Entity Framework Core.
CFA (Change-Tracking Approach) is used to track changes made to entities in memory and then save them to the database.
DFA (Database-First Approach) is used to generate entity classes and DbContext from an existing database schema.
CFA is useful when working with disconnected entities, while DFA is useful when working with an existing ...
Some of the top questions asked at the Nielsen Senior Software Developer interview -
based on 2 interviews
Interview experience
based on 4 reviews
Rating in categories
Data Analyst
211
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
191
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
165
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Research Executive
165
salaries
| ₹0 L/yr - ₹0 L/yr |
Research Executive
145
salaries
| ₹0 L/yr - ₹0 L/yr |
Kantar
GfK MODE
Euromonitor International
Dun & Bradstreet