Multiple choice technology databases

Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?

  1. Index

  2. Check constraint

  3. Default constraint

  4. Referential constraint
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A default constraint only provides a fallback value when no value is specified - it doesn't restrict which values can be inserted. Check constraints restrict values to specific conditions. Referential constraints (foreign keys) restrict values to existing values in another table. Indexes can enforce uniqueness via unique constraints but don't restrict values otherwise.

Keep practicing — related questions