⟩ Explain 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 key C. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index D. For each data manipulation language 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 operation performed, the corresponding indexes are
automatically updated