10. What happens to secondary indexes if the primary XML index is dropped?
A. Nothing happens to secondary indexes. They remain defined on the table.
B. Secondary indexes will be dropped.
C. Non-XML indexes are dropped.
D. All XML and non-XML indexes are dropped.
The correct answer is B. Answers A, C, and D are incorrect because each
of these statements does not represent the result of dropping the primary
XML index.
Bạn đang xem 10. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P159 PPSX