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