| 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 ? (Twist :- can you explain the star schema for OLAP ? ) |
| 12. What is DTS? |
|
|
| 13. What is fillfactor ? (Twist :- When does plage split occurs ?) |
| 14. What is RAID and how does it work ? |
| 15. What's the difference between DELETE TABLE and TRUNCATE TABLE commands? |
| 16. What are the problems that can occur if you do not implement locking properly in SQL SERVER ? |
| 17. What are different transaction levels in SQL SERVER ?(Twist :- what are different types of locks in SQL SERVER ?) |
| 18. What are different locks in SQL SERVER ? |
| 19. Can we suggest locking hints to SQL SERVER ? |
| 20. What is LOCK escalation? |
| 21. What are the different ways of moving data/databases between servers and databases in SQL Server? |
| 22. What are advantages of SQL 2000 over SQl 7.0 ? |
| 23. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? |
| 24. What is difference between UNION and UNION ALL SQL syntax ? |
| 25. How can you raise custom errors from stored procedure ? |
| 26. What is ACID fundamental and what are transactions in SQL SERVER ? |
| 27. What is DBCC? |
| 28. What is purpose of Replication ? |
| 29. What are different type of replication supported by SQL SERVER ? |
| 30. What is BCP utility in SQL SERVER ? |
| 31. What are different types of triggers in SQl SERVER 2000 ? |
| 32. If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ? |
| 33. What is SQl injection ? |
