WHEN YOU USE CREATE XML INDEX( ) SYNTAX, WHAT TYPE OF INDEX ARE YOU...

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.