The DEFERRABLE constraint in DB2 allows for ________.

  • Deferring constraint checking until explicitly committed or rolled back
  • Deferring constraint checking until the end of the session
  • Deferring constraint checking until the end of the statement
  • Deferring constraint checking until the end of the transaction
The DEFERRABLE constraint in DB2 allows deferring the checking of constraints until the end of the transaction. This means that constraints associated with the data are not evaluated until the transaction is about to be committed. It enables temporarily violating constraints during the transaction as long as they are satisfied by the time the transaction is committed. This feature is useful in situations where it's necessary to insert or update data that temporarily violates constraints but will be rectified before the transaction is finalized. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *