Interview questions faced in month of September

1) In a cluster environment how do you apply service pack in SQL Server 2005 and SQL Server 2008?

2) How to verify cluster log file in SQL Server 2005 and SQL Server 2008?

3) What are the issues you faced in a Cluster environment?

4) What are the per-requisites to install SQL Cluster?

5) How to troubleshoot primary key violation in a Transaction Replication?

6) In which scenario the log file is full in Transaction Replication? How to troubleshoot?

7) How to troubleshoot memory bottle necks?

8) How do you troubleshoot, if my application is running very slow at database perspective?

9) What are the DMV's you generally used?

10) What is the DMV used to find fragmentation?

11) What is the command you used to find blocking?

12) What are the index related DMV's?

13) How to find Orphand users? How will you fix Orphand users?

14) In Perfmon, what are the counters you use?

15) How to check deadlock?

16) Who fix the deadlocks?

17) In High Availability, how many servers do you configure?

18) The Schedule is every sunday night at 11:00 PM we have a full backup and every next day we have a differential backup and every 15 minutes we have a T-log backup. On Wednesday after differential backup my database is crashed. How do you recover? If the differential backup is crashed. How do you recover?

19) What is Resource Database? What is use of it?

20) My database gone into suspect mode. What may be the reasons? As a DBA what will you do?

21) As a DBA what are the checks you perform if log file is full in SQL Server?

22) Why and when will you take a tail log backup?

23) How to take tail log backup?

24) What is point-in-time restoration?

25) At 1:00 P.M we have T-log backup and 1:15 P.M database is crashed. How to recover? If customer needs the database upto 1:10 P.M. How will you recover?