Explanation:DROP INDEX MOVE TO applies only to clustered indexes. 9. The SORT_IN_TEMPDB option cannot be set for ________ statements.
A. ALTER INDEX
B. DROP INDEX
C. CREATE INDEX
D. All of the mentioned
Answer:A
Explanation:DROP INDEX MOVE TO applies only to clustered indexes. 9. The SORT_IN_TEMPDB option cannot be set for ________ statements.
A. ALTER INDEX B. DROP INDEX C. CREATE INDEX D. All of the mentioned
Explanation:The temporary mapping index is always created in the same filegroup or partition scheme as the target index. 10. Which of the following query will disable the index on Employee table ?