PrepAway - Latest Free Exam Questions & Answers

Which statement are true about the DROP INDEX statement options?

Which statement are true about the DROP INDEX statement options? (Select two.)

PrepAway - Latest Free Exam Questions & Answers

A.
The RESTRICT option, by default, will not allow an index to be dropped if it is being used to
validate a constraint.

B.
The RESTRICT option, if specified, will not allow an index to be dropped if it has dependent
programs.

C.
The CASCADE option, if specified, will drop both the index and any constraints using the index for
validation.

D.
The CASCADE option, by default, will invalidate the dependent programs.

E.
The CASCADE option, if specified, will drop the underlying table before dropping the index.


Leave a Reply