Which index rebuild operation in SQL Server 2005

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

(Continued from previous question...)

Which index rebuild operation in SQL Server 2005 can be performed online?

Answer: Both of these can be online.

Explanation: Both of these options can be performed in an online manner. The REORGANIZE option is always online and you can specify ONLINE=ON for the REBUILD option.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005, can you include a user-defined role as a member of another user-defined role?
• In SQL Server 2000, how can you send an alert without sending a message to the client?
• Which RAID levels store parity information?
• Which of the queries is the best one for Janice to use to return the information she has been requested to provide?
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• What is the best way to have your junior DBA do this?
• The queries still seem slow immediately after snapshot creation. Why?
• True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
• Which is larger in size in SQL Server 2005 if you are using symmetric keys?
• Which of the following datatypes can be represented in a SQL_VARIANT datatype?
• More...