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.