Common DBA interview Questions..
===============================
1. Explain
about your SQL Server DBA Experience.
2. What are the different SQL Server Versions you have worked on?
3. What are the different types of Indexes available in SQL Server?
4. What is the difference between Clustered and Non-Clustered Index?
5. What are the new features in SQL Server 2005 when compared to SQL Server 2000?
6. What are the High-Availability solutions in SQL Server and differentiate them briefly.
7. How do you troubleshoot errors in a SQL Server Agent Job?
8. What is the default Port No on which SQL Server listens?
9. How many files can a Database contain in SQL Server?How many types of data files exists in SQL Server? How many of those files can exist for a single database?
10. What is DCL?
11. What are the commands used in DCL?
12. What is Fill Factor?
13. What is the default fill factor value?
14. What is normalization? Explain different levels of normalization?
15. What is denormalization and when would you go for it?
16. How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
17. What's the difference between a primary key and a unique key?
18. What are user defined data types and when you should go for them?
19. What is bit data type and what's the information that can be stored inside a bit column?
20. What are defaults? Is there a column to which a default can't be bound?
21. What is a transaction and what are ACID properties?
22. What type of Index will get created after executing the above statement?
23. What's the maximum size of a row?
24. What are constraints? Explain different types of constraints.
25. What is RAID and what are different types of RAID configurations?
26. What are the steps you will take to improve performance of a poor performing query?
27. What are the steps you will take, if you are tasked with securing an SQL Server?
28. What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
29. What is blocking and how would you troubleshoot it?
30. How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
31. What are statistics, under what circumstances they go out of date, and how do you update them?
32. What are the different ways of moving data/databases between servers and databases in SQL Server?.
33. Explain different types of BACKUPs available in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
34. How to determine the service pack currently installed on SQL Server?
35. What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
36. Write down the general syntax for a SELECT statements covering all the options.
37. What is a join and explain different types of joins.
38. What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
39. What is the system function to get the current user's user id?
40. What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
41. What do you think of this implementation? Can this be implemented better?
42. What is a self-join? Explain it with an example.
43. What are the steps to improve the performance of a query?
44. How would you use the SP_ functions to identify the blocking problems?
45. What are the different types of backups?
46. What are the different levels of isolation?
47. How can you start the SQL Server in the single user mode and the minimal configuration mode?
48. How can you know that statistics should be updated?
49. What is replication in SQL Server?
2. What are the different SQL Server Versions you have worked on?
3. What are the different types of Indexes available in SQL Server?
4. What is the difference between Clustered and Non-Clustered Index?
5. What are the new features in SQL Server 2005 when compared to SQL Server 2000?
6. What are the High-Availability solutions in SQL Server and differentiate them briefly.
7. How do you troubleshoot errors in a SQL Server Agent Job?
8. What is the default Port No on which SQL Server listens?
9. How many files can a Database contain in SQL Server?How many types of data files exists in SQL Server? How many of those files can exist for a single database?
10. What is DCL?
11. What are the commands used in DCL?
12. What is Fill Factor?
13. What is the default fill factor value?
14. What is normalization? Explain different levels of normalization?
15. What is denormalization and when would you go for it?
16. How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
17. What's the difference between a primary key and a unique key?
18. What are user defined data types and when you should go for them?
19. What is bit data type and what's the information that can be stored inside a bit column?
20. What are defaults? Is there a column to which a default can't be bound?
21. What is a transaction and what are ACID properties?
22. What type of Index will get created after executing the above statement?
23. What's the maximum size of a row?
24. What are constraints? Explain different types of constraints.
25. What is RAID and what are different types of RAID configurations?
26. What are the steps you will take to improve performance of a poor performing query?
27. What are the steps you will take, if you are tasked with securing an SQL Server?
28. What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
29. What is blocking and how would you troubleshoot it?
30. How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
31. What are statistics, under what circumstances they go out of date, and how do you update them?
32. What are the different ways of moving data/databases between servers and databases in SQL Server?.
33. Explain different types of BACKUPs available in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
34. How to determine the service pack currently installed on SQL Server?
35. What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
36. Write down the general syntax for a SELECT statements covering all the options.
37. What is a join and explain different types of joins.
38. What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
39. What is the system function to get the current user's user id?
40. What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
41. What do you think of this implementation? Can this be implemented better?
42. What is a self-join? Explain it with an example.
43. What are the steps to improve the performance of a query?
44. How would you use the SP_ functions to identify the blocking problems?
45. What are the different types of backups?
46. What are the different levels of isolation?
47. How can you start the SQL Server in the single user mode and the minimal configuration mode?
48. How can you know that statistics should be updated?
49. What is replication in SQL Server?
No comments:
Post a Comment