You are writing a new stored procedure to perfor

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragments the indexes in an online manner. What command should you use?

Answer: ALTER INDEX with the REORGANIZE option

Explanation: You should use the ALTER INDEX with the REORGANIZE option because the DBCC commands have been deprecated.

(Continued on next question...)

Other Job Interview Questions

• What does the CEILING() function do?
• You wish to back up the symmetric key used to protect data on the Reporting Services 2005 instance installed on Sales01. From your workstation, what command do you use?
• What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?
• What else should you configure on these instances?
• You need to remove a large table from your database ...
• When you declare an XML variable in SQL Server 2005, what are the two types of typed XML data. What are they?
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• SELECT USER_NAME() -- Returns Andy
• What does the CEILING() function do?
• Which types of replication work with Oracle publishers?
• More...