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 Indexes should be created on columns that are frequently referenced as part of an expression.

D A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.