Wednesday, March 24, 2010

SQL Server DBA Interview Questions Collection

1. What's the difference between a primary key and a unique key?
2. ACID stands for? Define transaction?
3. CREATE INDEX myIndex ON myTable (myColumn) what type of Index will get created after executing the above statement?
4. What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
5. What's the maximum size of a ……..?
6. What are constraints? Explain different types of constraints.
7. What is RAID and what are different types of RAID configurations?
8. What are the steps you will take to improve performance of a poor performing query?
9. What are the steps you will take, if you are tasked with securing an SQL Server?
10. What is the use of DBCC commands? Give some DBCC commands?
11. What are the different ways of moving data/databases between servers and databases in SQL Server?
12. What is database replicaion? What are the different types of replication you can set up in SQL Server?
13. What is a join and explain different types of joins.
14. Can you have a nested transaction?
15. What is a Stored Procedure? Examples of stored procedures
16. What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
17. What is Cursor?
18. What are cursors? Explain different types of cursors. What are the disadvantages of cursors?
19. What is a view?
20. What is an Index? What are the types of indexes available with SQL Server?
21. What is the system function to get the current user's user id?
22. What is the basic difference between clustered and a non-clustered index?
23. What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
24. What is normalization? Explain different levels of normalization
25. What is denormalization and when would you go for it?
26. Which TCP/IP port does SQL Server run on?
27. From where can you change the default port?
28. When do you use SQL Profiler?
29. What is a Linked Server?
30. Can you link only other SQL Servers or any database servers such as Oracle?
31. What are the advantages of using Stored Procedures?
32. Which stored procedure will you be running to add a linked server?
33. What are the OS services that the SQL Server installation adds?
34. Can you explain the role of each service?
35. How do you troubleshoot SQL Server if its running very slow?
36. What are the authentication modes in SQL Server?
37. Where do you think the user’s names and passwords will be stored in sql server?
38. What is DTS?
39. What is BCP?
40. What should we do to copy the tables, schema and views from one SQL Server to another?
41. Determine where to store backups
42. What are the types of backups
43. What's the difference between stored procedures and triggers?
44. What is Security?
45. How to hide/show system tables and other system objects in SQL Server Enterprise Manager?
46. Can you restore a 7.0 master or msdb backup to 2000?
47. How do I copy DTS packages from SQL on one machine to another?
48. How do I rename a database?
49. How do I start SQL Server in single user mode?
50. How to find out all active SQL Servers in a LAN (Local Area Network)
51. How to import a trace file into a table?
52. Where is the backup and restore history information kept?
53. What causes a suspect database? How can I fix this?
54. How do I make a DTS package log to a text file?.
55. What is Dirty reads?
56. What is Isolation Levels? What are the types of Transaction Isolation Levels?
57. How to pass a list of values or array to SQL Server stored procedure?
58. How tempdb works?
59. What is FillFactor?
60. How index works?
61. Explain the sql cluster installation and requirement.
62. What is brain split scenario?
63. What is the new type of backup and restore introduce in 2005
64. What is orphan log in?
65. How to transfer table from primary group to secondary group?
66. What is TCP?
67. What is DHCP?
68. What’s the maximum size of a row and the maximum number of columns per table?
69. What are live locks
70. What is COMMIT & ROLLBACK statement in SQL?
71. What is difference between OSQL and Query Analyzer?
72. What is SQL what’s its uses and its component?
73. The DML component of SQL comprises four basic statements
74. What are Checkpoint in SQL Server?
75. Let’s say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
76. Define candidate key, alternate key, and composite key.
77. What is SQL Service Broker in SQL Server 2005?.
78. What is Database Partitioning in SQL Server 2005?
79. What is Endpoint?
80. Define SQL Server.
81. Define Database.
82. What is denormalization?
83. How do you implement one-to-one in SQL Server?
84. How do you implement one-to-many in SQL Server?
85. How do you implement many-to-many SQL Server?
86. What are User Defined Datatypes
87. What is bit datatype?
88. Define candidate key, alternate key, composite key.
89. Define composite key.
90. Define default constraint?
91. What is lock escalation?
92. Define SQL Profiler
93. Explain SQL Server Service Manager.
94. What is SQL Query Analyzer?
95. Define DTS service in SQL Server.
96. What is Replication in SQL Server?
97. Define Bulk Copying and Distributed Queries of SQL Server
98. Define SQL Server Agent.
99. What are constraints in SQL Server?
100. What is an index?
101. Disadvantages of the Indexes are
102. Reasons of poor performance of query.
103. Ways to troubleshoot performance problems in SQL Server.
104. Steps to secure an SQL Server.
105. What is a deadlock and what is a live lock?
106. What is blocking?
107. Explain different types of BACKUPs available in SQL Server
108. What is database replicaion?
109. What are cursors in SQL Server?
110. What is an extended stored procedure in SQL Server?
111. What are triggers in SQL Server?
112. What is a self join in SQL Server?
113. Write some disadvantage of Cursor?
114. What is Log Shipping?
115. What are the different types of Locks?
116. What is Extent and types of Extent ?
117. Define COLLATION?
118. Where is users names and passwords stored in SQL Server?
119. How can we move data along with schema of the server object?
data base administrator. microsoft database administrator. sql questions and answers. interview questions for servers. database administrator interview questions. sql dba interview questions and answers. server interview. sql questions for interview. ms sql interview questions with answers. becoming a database administrator. server interview tips. microsoft sql interview questions. interview questions for server. interview sql questions. sql database interview questions. it database administrator. a database administrator. interview questions for database administrator. database sql interview questions. interview question on sql. interview questions server. sql interview question and answer. interview questions and answers on sql. t-sql interview question. sql questions and answers for interview. sql database interview questions and answers. database administrator interview. interview question for sql. sql interview question and answers. sql server database administrator interview questions. interview questions database administrator. sql question and answers. interview sql. interview questions on databases. microsoft server interview questions. microsoft sql interview questions and answers. server questions and answers. sql dba interview. sql server administrator interview questions and answers. sql server interview questions and answers for developers. database administrator questions. sql server interview questions and answers download. interview questions for a database administrator. interview questions and answers for database administrator. sql dba interview questions with answers

2 comments:

Can you please post the answers.....

Post a Comment