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