Multiple choice technology databases

For which constraints are indexes created when the constraint is added?

  1. Check

  2. Unique

  3. Primary key

  4. not null
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

Creating a PRIMARY KEY or UNIQUE constraint automatically generates a corresponding index to enforce uniqueness. CHECK and NOT NULL constraints do not automatically create indexes.

Keep practicing — related questions