Multiple choice technology databases

Can Check constraint be used for self referential integrity ?

  1. Yes

  2. No

  3. Not in Oracle

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

CHECK constraints can enforce conditions on columns including self-referential logic within the same row. A CHECK constraint can reference other columns in the same table to validate row-level data integrity. For example, CHECK (end_date >= start_date) ensures referential integrity within the row itself.

Keep practicing — related questions