What is a transaction and what are ACID properties?

What is the difference between COMMIT and ROLLBACK process in Database ?

What is the role of SQL server agent?

What are the common performance issues in SQL Server?

How to create an empty table from an existing table?

What are aggregate and scalar functions?

What is difference between Union, minus and Interact commands?

What is recursive stored procedure?

What are all different types of collation sensitivity?

What are the types of subquery?