Multiple choice technology databases

Which one of the following constraints enforces domain integrity?

  1. Primary key constraint

  2. Check constraint

  3. Foreign key constraint

  4. Unique constraint
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Domain integrity ensures that data values fall within defined valid domains for each column. Check constraints enforce domain integrity by validating column values against specific conditions (e.g., age > 0, price BETWEEN 0 AND 1000). Primary key and unique constraints enforce entity integrity (row uniqueness), while foreign key enforces referential integrity between related tables.

Keep practicing — related questions