Oracle
1Z0-052 · Question #92
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 tw
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #92. The question stem and answer options stay visible for context.
Managing Schema Objects
Question
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? (Choose two.)
Options
- AIt fails if any existing row violates the constraint.
- BIt does not validate the existing data in the table.
- CIt enables the constraint to be enforced at the end of each transaction.
- DIt prevents insert, update, and delete operations on the table while the constraint is in the process of
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#constraints#ENABLE VALIDATE#ALTER TABLE#data validation