Tuesday, April 01, 2008

.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)?

No comments: