Multiple choice technology databases

For which two constraints does the Oracle Server implicitly create a unique index?

  1. NOT NULL and PRIMARY KEY

  2. PRIMARY KEY and UNIQUE key

  3. FOREIGN KEY and PRIMARY KEY

  4. CHECK

  5. UNIQUE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle database automatically and implicitly creates a unique index to enforce unique value constraints. This occurs specifically when a PRIMARY KEY or a UNIQUE key constraint is defined on a table, ensuring fast lookups and preventing duplicate entries, whereas other constraints do not.

Keep practicing — related questions