Multiple choice technology databases

For which two constraints,does the oracle server implicitly creates an index ?

  1. NOT NULL

  2. PRIMARY KEY

  3. FOREIGN KEY

  4. CHECK

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

Oracle automatically creates a unique index when you define a PRIMARY KEY or UNIQUE constraint to enforce uniqueness. This index supports quick lookups to check for duplicate values before insert/update operations. NOT NULL and CHECK constraints are validated through column value inspection, while FOREIGN KEY constraints are enforced through referential integrity checks - none of these require automatic indexes.

Keep practicing — related questions