Which statements are correct regarding indexes?

Which statements are correct regarding indexes? (Choose all that apply.)

Which statements are correct regarding indexes? (Choose all that apply.)

A.
When a table is dropped, the corresponding indexes are automatically dropped.

B.
A FOREIGN KEY constraint on a column in a table automatically creates a nonunique index.

C.
A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.

D.
For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Manish

Manish

A.
When a table is dropped, the corresponding indexes are automatically dropped.
C.
A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
D.
For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated.