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.

The correct answer is C. Answer A is not correct because running CREATE

PRIMARY XML INDEX( ) will result in an error due to the existing XML

indexes. Answer B is incorrect because the non-XML columns do not impact

the XML primary key in this situation. Answer D will work in this situation,

but it is not necessary and, in some cases, not practical to drop the table and

re-create. This answer is not the best example of what can be done and is

therefore incorrect.