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.