Question

Point out the correct statement.

(a) If ALTER INDEX ALL is specified, it applies to both non-XML and XML indexes

(b) The rebuild and set option IGNORE_DUP_KEY is not valid for XML indexes

(c) The option DROP_EXISTING is permitted in the ALTER INDEX statement

(d) The modifications of the primary key constraint in the user table are not automatically propagated to XML indexes

The question was asked in final exam.

The question is from Working With XML Data in division Beyond Relational of SQL Server

Answer 1

Correct answer is (c) The option DROP_EXISTING is permitted in the ALTER INDEX statement

For explanation I would say: The user must drop the XML indexes first and then re-create them.