Common SQL Interview questions

1. What is Database?
2. Define primary key, foreign key and unique key?
3. Difference between clustered index and non clustered index?
4. What are the files associated with a database in SQL server?
5. What is normalization?
6. What is a join and what types of joins in SQL Server?
7. What are constraints in SQL Server?
8. What is a view? How to update a view in SQL Server?
9. Difference between Union and Union ALL?
10. Difference between Stored procedure and function?
11. Difference between truncate and delete?
12. What is a linked server?
13. What is difference between clustered index and non clustered index?
14. What is cursor and what are alternatives to cursor in sql server?
15. What are DBCC commands?
16. What is a trigger and types of triggers in SQL server?
17. What are isolation levels in SQL server?
18. What is SQL profiler why is it used?
19. What is Activity monitor why is it used?
20. What is SQL server agent?
21. What is SQL Server Browser?
22. What are ACID properties in a database?
23. What are DMV’s ?
24. What are the types of Backups in SQL server?
25. What is log shipping and why is it used?