6. When you use CREATE XML INDEX( ) syntax, what type of index are you
creating?
A. A primary XML index
B. A clustered index
C. A secondary XML index
D. A nonclustered index
The correct answer is C; this syntax will create a secondary XML index.
Answer A is not correct because the syntax CREATE PRIMARY XML
INDEX( ) is needed to create a primary XML index. Answers B and D are
incorrect because they do not apply to creating an XML index.
Bạn đang xem 6. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P159 PPSX