WHICH OF THE FOLLOWING DDL STATEMENTS WILL CREATE A PRIMARY XML IND...

8. Which of the following DDL statements will create a primary XML index?

A. CREATE XML INDEX( )

B. ALTER INDEX( )

C. DROP INDEX( )

D. CREATE PRIMARY XML INDEX( )

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

a nonprimary XML index, and answers B and C are incorrect because

the request was to create a primary XML index, not to ALTER or DROP

the index.