Que: 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: The option DROP_EXISTING is permitted in the ALTER INDEX statement

Leave a Comment