Which statements are correct regarding indexes?

Question

TuteeHUB · Accepted Answer

NA

TuteeHUB · Answer

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

TuteeHUB · Answer

For each DML operation performed, the corresponding indexes are automatically updated

TuteeHUB · Answer

A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index

TuteeHUB · Answer

All of the mentioned

1.	Which statements are correct regarding indexes?
A.	When a table is dropped, the corresponding indexes are automatically dropped
B.	For each DML operation performed, the corresponding indexes are automatically updated
C.	A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index
D.	All of the mentioned
Answer» E.

Discussion