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.
Bạn đang xem 9. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P159 PPSX