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
Answer:A
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
Explanation:The user must drop the XML indexes first and then re-create them.