Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 34 of 50

Marks: +1, -0

Which three statements are correct regarding indexes? (Choose three.)

A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically attempts to create a unique index.
Indexes should be created on columns that are frequently referenced as part of any expression.
When a table is dropped, corresponding indexes are automatically dropped.
For each DML operation performed on a table, the corresponding indexes are automatically updated if required.

Go to Question:

Prev Question

Next Question