Filter interviews by
I applied via AmbitionBox and was interviewed before Aug 2022. There were 3 interview rounds.
A stored procedure is a prepared SQL code that can be saved and reused.
Stored procedures are used to perform a specific task or set of tasks in a database.
They can accept input parameters and return output parameters.
Stored procedures can improve performance by reducing network traffic and improving security.
Examples: sp_GetCustomerDetails, sp_InsertEmployee
A view in SQL is a virtual table based on the result set of a SELECT query. There are different types of views like simple, complex, indexed, etc.
Views are used to simplify complex queries by storing them as a virtual table.
Types of views include simple views, complex views, indexed views, etc.
Views can be used to restrict access to certain columns or rows of a table.
Views can improve performance by pre-computing expen
Functions return a value while stored procedures do not. Functions can be used in SQL statements, while stored procedures cannot.
Functions return a single value, while stored procedures do not necessarily return any value.
Functions can be used in SQL statements like SELECT, WHERE, etc., while stored procedures cannot be used in such statements.
Functions are called using SELECT statement, while stored procedures are cal...
Query to display nth highest salary in SQL
Use the ORDER BY clause to sort salaries in descending order
Use the DISTINCT keyword to eliminate duplicates
Use the LIMIT clause to specify the nth highest salary
I appeared for an interview before Sep 2016.
I applied via Recruitment Consultant and was interviewed before Sep 2018. There were 4 interview rounds.
I appeared for an interview in Jul 2017.
I am a software engineer with experience in developing and maintaining software applications.
I have a strong background in programming languages such as Java, C++, and Python.
I have worked on various projects, including developing web applications and implementing software solutions.
I am skilled in problem-solving and debugging, ensuring efficient and effective software development.
I have experience in collaborating wi...
I learned valuable teamwork and problem-solving skills during my summer internship.
Developed strong collaboration skills by working with a team of software engineers to complete projects
Gained experience in troubleshooting and debugging software issues
Learned to effectively communicate and present technical concepts to both technical and non-technical stakeholders
Improved problem-solving abilities by identifying and re...
Java is an object-oriented language while C is a procedural language.
Java is platform-independent while C is platform-dependent.
Java has automatic garbage collection while C requires manual memory management.
Java has built-in support for multithreading while C requires external libraries.
Java has a larger standard library compared to C.
Java is more secure than C due to its strong type checking and exception handling.
C ...
Pointers are variables that store memory addresses of other variables in programming languages.
Pointers allow direct access and manipulation of memory locations.
They are commonly used in programming languages like C and C++.
Pointers can be used to pass variables by reference, allowing modifications to the original value.
They can also be used to dynamically allocate memory.
Example: int* ptr; // declares a pointer to an
In 5 years, I see myself as a senior software engineer leading a team of developers.
Leading a team of developers
Working on complex projects
Continuing to learn and grow in my role
Contributing to the success of the company
based on 2 interviews
Interview experience
based on 16 reviews
Rating in categories
Database Developer
34
salaries
| ₹2.4 L/yr - ₹5.6 L/yr |
SQL Developer
16
salaries
| ₹2.4 L/yr - ₹3.3 L/yr |
Software Engineer
3
salaries
| ₹3 L/yr - ₹3.6 L/yr |
Software Developer
3
salaries
| ₹3 L/yr - ₹3.6 L/yr |
TCS
Accenture
Wipro
Cognizant