Explanation:DROP INDEX does not require space when you are dropping a clustered index offline without specifying the MOVE TO clause and nonclustered indexes do not exist. 8. Which of the following index operation require additional disk space ?
A. UPDATE INDEX
B. DROP INDEX MOVE TO
C. ALTER INDEX ADD CONSTRAINT
D. All of the mentioned
Answer:A
Explanation:DROP INDEX does not require space when you are dropping a clustered index offline without specifying the MOVE TO clause and nonclustered indexes do not exist. 8. Which of the following index operation require additional disk space ?
A. UPDATE INDEX B. DROP INDEX MOVE TO C. ALTER INDEX ADD CONSTRAINT D. All of the mentioned
Explanation:DROP INDEX MOVE TO applies only to clustered indexes. 9. The SORT_IN_TEMPDB option cannot be set for ________ statements.