DSoft Infosystem Interview Questions and Answers

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...read more

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