YOU HAVE A TABLE CONTAINING COLUMNS WITH THE XML DATA TYPE. NO PRIM...

7. You have a table containing columns with the XML data type. No primary key has been assigned yet, but indexes have been set up on a few of the other table columns, including columns defined with the XML data type. You want to define the primary key. Which of the following best describes what you can do?A. Use the CREATE PRIMARY XML INDEX() syntax to create the primary key.B. Drop all indexes on the non-XML columns.C. Drop all indexes on XML columns.D. Drop the table and re-create, defining the primary key on the XML column first.