.NET Interview questions and Answers: 10

SQL SERVER

1. What is normalization? What are different type of normalization?
2. What is denormalization ?
3. What is a candidate key ?
4. What are different types of joins and whats the difference between them ?
5. What are indexes and What is the difference between clustered and nonclustered indexes?
6. How can you increase SQL performance ?
7. What is the use of OLAP ?
8. What's a measure in OLAP ?
9. What are dimensions in OLAP ?
10. What are levels in dimensions ?
11. What are fact tables and dimension tables in OLAP ?
12. Twist :- can you explain the star schema for OLAP ?
13. What is DTS?
14. What is fillfactor ?
15. Twist :- When does plage split occurs ?
16. What is RAID and how does it work ?
17. What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
18. What are the problems that can occur if you do not implement locking properly in SQL SERVER ?
19. What are different transaction levels in SQL SERVER ?
20. Twist :- what are different types of locks in SQL SERVER ?
21. What are different locks in SQL SERVER ?
22. Can we suggest locking hints to SQL SERVER ?
23. What is LOCK escalation?
24. What are the different ways of moving data/databases between servers and databases in SQL Server?
25. What are advantages of SQL 2000 over SQl 7.0 ?
26. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
27. What is difference between UNION and UNION ALL SQL syntax ?
28. How can you raise custom errors from stored procedure ?
29. What is ACID fundamental and what are transactions in SQL SERVER ?
30. What is DBCC?
31. What is purpose of Replication ?
32. What are different type of replication supported by SQL SERVER ?
33. What is BCP utility in SQL SERVER ?
34. What are different types of triggers in SQl SERVER 2000 ?
35. If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?
36. What is SQl injection ?
37. What’s the difference between Stored Procedure (SP) and User Defined Function (UDF)?