You have two tables with referential integrity enforced between them. You need to insert data to
the child table first because it is going to be a long transaction and data for the parent table will be
available in a later stage, which can be inserted as part of the same transaction. View the Exhibit to
examine the commands used to create tables. Which action would you take to delay the referential
integrity checking until the end of the transaction?
See the Exhibit:
Examine the commands used to create tables:
Which action would you take to delay the referential integrity checking until the end of the transaction?
A.
Set the constraint to deferred before starting the transaction
B.
Alter the constraint to NOVALIDATE state before starting the transaction
C.
Enable the resumable mode for the session before starting the transaction
D.
Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction
Exhibit not showing
DEFERRABLE Clause
The DEFERRABLE and NOT DEFERRABLE parameters indicate whether or not, in subsequent transactions, constraint checking can be deferred until the end of the transaction using the SET CONSTRAINT(S) statement.
Specify DEFERRABLE to indicate that in subsequent transactions you can use the SET CONSTRAINT[S] clause to defer checking of this constraint until after the transaction is committed.