Filter interviews by
I applied via Company Website and was interviewed before Sep 2021. There were 2 interview rounds.
The answer to the question is to perform a join operation on the table to retrieve the manager name with respective employee name.
Use a SQL query to join the table on the manager ID
Select the manager name and employee name from the joined table
Display the manager name with respective employee name
To find the 3rd highest salary of any Employee from a table, we can use the SQL query with the 'ORDER BY' and 'LIMIT' clauses.
Write an SQL query to select the distinct salaries from the table in descending order.
Use the 'LIMIT' clause to limit the result to the third row.
The selected salary will be the 3rd highest salary of any employee.
I applied via LinkedIn and was interviewed in Jan 2021. There were 3 interview rounds.
posted on 4 Oct 2024
I applied via Referral and was interviewed in Sep 2024. There were 3 interview rounds.
Three DSA questions one on likedlist one on BST and one on maps
Smart pointers in C++ provide automatic memory management and help prevent memory leaks.
Smart pointers are objects that manage the memory of a pointer automatically.
They ensure that memory is deallocated when it is no longer needed.
Examples include unique_ptr, shared_ptr, and weak_ptr.
DSA questions on graph and lots of puzzles
I appeared for an interview in Apr 2022.
I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.
I applied via Naukri.com and was interviewed before Sep 2021. There were 4 interview rounds.
I applied via Job Fair and was interviewed in Jun 2022. There were 3 interview rounds.
Cloud , Big Data , Jenkins , CICD Pipeline
Finally block is used in try-catch-finally statement to execute code after try and catch blocks.
Finally block is optional and can be used with try-catch or try-catch-catch statements.
It is executed regardless of whether an exception is thrown or not.
It is often used to release resources like file handles, database connections, etc.
Example: try { //code } catch (Exception e) { //code } finally { //code }
To get the second largest salary from a table, you can use the SQL query with the ORDER BY and LIMIT clauses.
Write a SQL query to select the distinct salaries from the table.
Order the salaries in descending order using the ORDER BY clause.
Use the LIMIT clause to retrieve the second row from the result set.
Joins are used to combine data from two or more tables based on a related column.
Types of joins include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and matching rows from the left table.
Full outer join returns all row...
Integration patterns are design patterns used to integrate different systems and applications.
Point-to-Point: Direct communication between two systems.
Publish-Subscribe: One-to-many communication where a message is broadcast to multiple recipients.
Message Broker: Middleware that facilitates communication between different systems.
Shared Database: Systems share a common database to exchange information.
File Transfer: Da...
I prefer a collaborative working model where team members communicate openly and work together towards common goals.
Open communication among team members
Collaborative decision-making
Regular team meetings to discuss progress and challenges
Flexibility to adapt to changing project requirements
I appeared for an interview in Nov 2022.
Basic questions on generic IT terms
based on 1 interview
Interview experience
based on 5 reviews
Rating in categories
Technical Consultant
56
salaries
| ₹4.3 L/yr - ₹11 L/yr |
Cloud Operations Engineer
29
salaries
| ₹4.1 L/yr - ₹9.5 L/yr |
Associate Consultant
24
salaries
| ₹3.2 L/yr - ₹6 L/yr |
Senior Software Engineer
18
salaries
| ₹7 L/yr - ₹15 L/yr |
Senior Technical Consultant
17
salaries
| ₹7 L/yr - ₹14.5 L/yr |
Apisero
Actalent Services
Cyber Infrastructure
TestingXperts