Multiple choice technology databases

What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?

  1. Check

  2. Range

  3. Referential

  4. Informational
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A Check constraint can enforce that the value of one column never exceeds another by using a condition like 'column1 <= column2'. Check constraints validate row data against user-defined conditions. Range, Referential, and Informational are not standard DB2 constraint types - Referential integrity is enforced through foreign key constraints.

Keep practicing — related questions