Go back to 1Z0-031 - Oracle9i Database: Fundamentals I

Question :-

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 ? Click here.