SQL SERVER

0. What is normalization? What are different type of normalization?

1. What is denormalization ?

2. What is a candidate key ?

3. What are different types of joins and whats the difference between them ?

4. What are indexes and What is the difference between clustered and nonclustered indexes?

5. How can you increase SQL performance ?

6. What is the use of OLAP ?

7. What's a measure in OLAP ?

8. What are dimensions in OLAP ?

9. What are levels in dimensions ?

10. What are fact tables and dimension tables in OLAP ? (Twist :- can you explain the star schema for OLAP ? )

11. What is DTS?

12. What is fillfactor ? (Twist :- When does plage split occurs ?)

13. What is RAID and how does it work ?

14. What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

15. What are the problems that can occur if you do not implement locking properly in SQL SERVER ?

16. What are different transaction levels in SQL SERVER ?(Twist :- what are different types of locks in SQL SERVER ?)

17. What are different locks in SQL SERVER ?

18. Can we suggest locking hints to SQL SERVER ?

19. What is LOCK escalation?