Oracle Certification Interview Question:

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

Submitted by: Administrator

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
Submitted by: Administrator