WHAT EFFECT DOES DROPPING A SECONDARY XML INDEX HAVE ON A TABLE TH...

11. What effect does dropping a secondary XML index have on a table that has

a primary XML index defined?

A. The primary XML index is automatically dropped and needs to be re-

created.

b. All secondary indexes will be dropped.

c. Only the XML index defined in the DDL statement will be dropped.

There is no effect on other indexes.

d. All XML and non-XML indexes are dropped.

The correct answer is C. Answers A, C, and D are incorrect because each

of these statements does not represent the result of dropping a secondary

XML index.