SQL Server DBA Interview Questions 7

                                          Interview Questions

   1. What are the System Databases in SQL Server 2000/2005? Explain?
 
   2. What is the main Differences between Clustered Index and Non Clustered Index?
  
   3. How to Truncate the Transaction Log?
 
   4. Explain the Difference between Join/Union or Union/Union All?

   5. Difference between  Delete/Truncate or Delete/Drop?

   6. Define Normalization?Explain the Normal Forms?

   7. Define Denormalization?Use of Denormalization?

   8. What is file group?
 
   9. Define Isolation level?How many types of Isolation level?what is the default Isolation level?
 
  10. What is the Difference between SQL Server 2000/ 2005?

  11. What is Deadlock?How to avoid deadlock?

  12. Difference  between locking and Deadlock?
 
  13. Explain Difference between Index Rebuild and Index Defrag?

  14. How to troubleshoot when SQL SERVER is running slow.

  15. what is the difference between Logshipping and Replication.

  16. What is the purpose of Logshipping.

  17. How to troubleshoot when msdb is running slow.

  18. What do u mean by Disaster of Recovery.

  19. what are the default databases.

  20. How to connect to SQL SERVER.

  21. How many types of authentications are there?

  22. Which authentication is the best one(Windows or sql server authentication)?

  23. How to Rebuild Master database?

  24. What is the architecture of Log-shipping?

  25. What is Replication?How many types of Replication are there?

  26. What are the Monitoring tools?

  27. How many backup's are there.What is the difference between full and differential database?

  28. Explain the differences between Database Mirroring and Logshipping?

  29. Explain SQL Profiler?What is the output of SQL Profiler?

  30. Explain Fragmentation?What is Command of Fragmentation?

  31. What do u mean by Index tunning wizard?
 
  32. What do u mean by Checkpoint?

  33. How will we come to know that backup is failed?

  34. what do u mean by DBCC Command?What are the commands u use in ur company?

  35. How to move/copy the data from one database to other database or from  one sever to other server in SQLSERVER?

  36. What is command u use to know the version of SQL SERVER in T-SQL?

  37. What are the TCP/IP protocal in SQL Server?

  38. How  will u troubleshoot if Insallation is not completed properly?

  39. How  will u bring the database if it is in suspect status?

  40. How to troubleshoot if tempdb is full?