Filter interviews by
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 Recruitment Consulltant and was interviewed in Jan 2022. There was 1 interview round.
Joins are used to combine data from two or more tables based on a related column between them.
Use JOIN keyword followed by the name of the table to join
Specify the columns to be selected using SELECT keyword
Use ON keyword to specify the related column between tables
Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
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 in Aug 2024. There was 1 interview round.
Functions return a single value, while stored procedures can perform multiple operations and return multiple values.
Functions return a single value, while stored procedures can return multiple values.
Functions are called in SQL statements, while stored procedures are called using EXECUTE statement.
Functions cannot have output parameters, while stored procedures can have output parameters.
Functions cannot modify server ...
Custom exceptions can be implemented in MVC by creating a new class that inherits from Exception class.
Create a new class that inherits from Exception class
Override the constructor to pass a custom message to the base Exception class
Throw the custom exception in the MVC controller or service layer
I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.
To get the 3rd last node of a linked list, we can use two pointers approach.
Start two pointers at the head of the linked list
Move the first pointer to the 3rd node from the beginning
Then move both pointers one node at a time until the first pointer reaches the end
FIFO stands for First In, First Out. LIFO stands for Last In, First Out.
FIFO is a method for organizing and manipulating a data buffer, where the first element added is the first to be removed.
LIFO is a method where the last element added is the first to be removed.
FIFO is like a queue, while LIFO is like a stack.
Example: In a FIFO queue, if elements A, B, and C are added in that order, they will be removed in the same...
I applied via Walk-in and was interviewed in Jul 2024. There were 2 interview rounds.
Model classes in UIKit are used to represent data in an application's user interface.
Model classes in UIKit typically subclass NSObject and are used to store and manage data for views.
They can include properties to represent different data fields, methods to manipulate the data, and sometimes protocols for delegation.
For example, a model class for a user profile in a social media app might have properties like username...
Project related questions
I was interviewed in Apr 2024.
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
based on 4 reviews
Rating in categories
Data Analyst
206
salaries
| ₹1.5 L/yr - ₹9 L/yr |
Analyst
199
salaries
| ₹1.8 L/yr - ₹9.3 L/yr |
Senior Research Executive
180
salaries
| ₹6.4 L/yr - ₹12.6 L/yr |
Manager
165
salaries
| ₹8.3 L/yr - ₹23 L/yr |
Research Executive
155
salaries
| ₹5.2 L/yr - ₹9 L/yr |
Kantar
GfK MODE
Euromonitor International
Dun & Bradstreet