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 applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.
I appeared for an interview before Jun 2016.
I am a passionate software developer with 5 years of experience in web development and a strong background in computer science.
5 years of experience in web development
Strong background in computer science
Passionate about software development
To separate personal and professional calls, and to ensure availability and accessibility.
Separate personal and professional calls
Ensure availability and accessibility
Maintain work-life balance
Avoid mixing personal and work-related contacts
I appeared for an interview in Sep 2016.
I am a passionate software developer with experience in Java, Python, and web development.
Experienced in Java, Python, and web development technologies
Strong problem-solving skills and ability to work in a team
Completed multiple projects including a web-based inventory management system
I appeared for an interview in May 2017.
I appeared for an interview in Jun 2017.
I appeared for an interview in May 2017.
I appeared for an interview in Aug 2017.
based on 2 interviews
Interview experience
based on 5 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