Multiple choice technology programming languages

For Which two constraints does the Oracle server implicitly create a unique index? (Choose Two)

  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 unique indexes for PRIMARY KEY and UNIQUE constraints to enforce uniqueness. NOT NULL, FOREIGN KEY, and CHECK constraints don't create unique indexes - they enforce other rules. The index ensures that duplicate values cannot be inserted.

Keep practicing — related questions