Multiple choice technology web technology

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

In Oracle, deferred constraints are validated only at transaction commit time, not after each DML operation. This allows intermediate constraint violations during transaction processing. Option A is incorrect because constraints ARE checked - just deferred. Option C describes behavior for initially deferred vs. immediate constraints. Option D is incorrect because there's no time-interval-based checking.

Keep practicing — related questions