（46）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、C、D）

ITPub博客

OCP 1Z0-051-46