29 Top Best Sql Server Interview Questions and Answers

SQL SERVER Interview Questions and Answers

1. What is normalization?
2. What are different types of normalization?
3. What is denormalization?
4. How can you increase SQL performance?
5. What is the difference between DELETE and TRUNCATE TABLE?
6. Can we suggest locking hints to SQL SERVER?
7. What is the difference between UNION and UNION ALL SQL syntax?
8. What is the purpose of Replication?
9. If we have multiple AFTER Triggers , can we specify sequence ?
10. What are the different types of joins?
11. What is DTS?
12. If locking is not implemented, what issues can occur?
13. What is LOCK escalation?
14. How can you raise custom errors from stored procedure?
15. What are the different types of replication supported by SQL SERVER?
16. What is SQL injection?
17. What is a candidate key?
18. What is fill factor ?
19. What are different transaction levels in SQL SERVER?
20. What are the different ways of moving data between databases in SQL Server?
21. What is ACID fundamental?
22. What is BCP utility in SQL SERVER?
23. What is the difference between Stored Procedure and User Defined Function?
24. What are indexes and what is the difference between clustered and nonclustered?
25. What is RAID and how does it work?
26. What are the different locks in SQL SERVER?
27. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
28. What is DBCC?
29. What are the different types of triggers in SQl SERVER?