Which statements are correct regarding indexes? (Choose all that apply.)
A.
For each data manipulation language (DML) operation performed, the corresponding indexes are
automatically updated.
B.
A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
C.
A FOREIGN KEY constraint on a column in a table automatically creates a non unique key
D.
When a table is dropped, the corresponding indexes are automatically dropped
35
down vote
accepted
In Oracle when dropping a table
all table indexes and domain indexes are dropped
any triggers defined on the table are dropped
if table is partitioned, any corresponding local index partitions are dropped
if the table is a base table for a view or if it is referenced in a stored procedure, function, or package, then these dependent objects are invalidated but not dropped