ALTER TABLE command with the ENABLE VALIDATE option effects of this command - Oracle Schema
Q. A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.
What are the two effects of this command?- Published on 13 Aug 15a. It fails if any existing row violates the constraint
b. It does not validate the existing data in the table
c. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
d. Both A & C
e. Both A & B
ANSWER: Both A & C