WHICH OF THE FOLLOWING DDL STATEMENTS WILL DISABLE A XML INDEX

9. Which of the following DDL statements will disable a XML index?

A. CREATE XML INDEX( )

B. ALTER INDEX [SD_XML_Data_customerAddress] ON XML_Table

C. DROP INDEX( )

D. ALTER INDEX [SD_XML_Data_customerAddress] ON XML_Table

DISABLE

The correct answer is D. The syntax in answer A is incorrect because it

creates a nonprimary XML index. Answer B is incorrect because the DISABLE

syntax is missing from the statement. Answer C is incorrect because this

statement will drop an index.