Prev Question
Next Question

Which statements are correct regarding indexes? (Choose all that apply.)

A.
A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.

B.
Indexes should be created on columns that are frequently referenced as part of any expression.

C.
When a table is dropped, the corresponding indexes are automatically dropped.

D.
For each DML operation performed, the corresponding indexes are automatically updated.

Explanation:
http://viralpatel.net/blogs/understanding-primary-keypk-constraint-in-oracle/

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *