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.
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



Leave a Reply 3

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


Sadiq Al Sahaf (Sojib)

Sadiq Al Sahaf (Sojib)

Correct Answer: A, B & D

Pablo

Pablo

Why are you responding with the answer that is already given? The reason this site is good is so you don’t see the answer until you are ready. If your answer was different I understand, but it is the exact same as what is given.

Nati

Nati

right u r my friend