Multiple choice technology databases

What is true in case of deferred constraints in Oracle?

  1. The Constraint condition is never checked

  2. The Constraint condition is checked only at the time of commiting the transaction

  3. The Constraint condition is checked only for newly inserted rows and will not be checked for already existing rows in the table

  4. The constraint condition is checked after a predefined time interval
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Deferred constraints in Oracle defer checking until the transaction is committed. This allows temporary violations during intermediate transaction steps, which are resolved before the changes are permanently saved.

Keep practicing — related questions