Explanation:ALTER statement is used to enable or disable the index. 7. The following index operations require no additional disk space :
A. ALTER INDEX
B. DROP INDEX
C. CREATE INDEX
D. All of the mentioned
Answer:A
Explanation:ALTER statement is used to enable or disable the index. 7. The following index operations require no additional disk space :
A. ALTER INDEX B. DROP INDEX C. CREATE INDEX D. All of the mentioned
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 ?