Go back to
1Z0-031 - Oracle9i Database: Fundamentals I
Which statement is true regarding enabling constraints?
ENABLE NOVALIDATE is the default when a constraint is enabled.
Enabling a constraint NOVALIDATE places a lock on the table.
Enabling a UNIQUE constraint to VALIDATE does not check for constraint violation if the constraint is deferrable.
A constraint that is currently disabled can be enabled in one of two ways: ENABLE NOVALIDATE or ENABLE VALIDATE.
Want to practice for 1Z0-031 - Oracle9i Database: Fundamentals I ?