Which of the following options best describes a domain constraint in a…
2025
Which of the following options best describes a domain constraint in a database system?
- A.
Guarantees that foreign keys link to a valid primary key
- B.
Restricts column values to a defined data type and valid range
- C.
Ensures each table name is unique
- D.
Prevents duplicate records in a table
Attempted by 258 students.
Show answer & explanation
Correct answer: B
A domain constraint in a database specifies the set of valid values that an attribute can hold. It restricts data based on rules such as data type, size, format, and range. For example, an age column may only allow integer values between 0 and 120.