Multiple choice technology databases

Which index is automatically created if you enable a UNIQUE KEY or PRIMARY KEY constraint

  1. cluster index

  2. simple index

  3. unique index

  4. functional index
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When you define a UNIQUE KEY or PRIMARY KEY constraint, Oracle automatically creates a unique index to enforce uniqueness. This index may be explicitly named or system-generated. Without a unique index, the database could not efficiently prevent duplicate values.

Keep practicing — related questions