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