Oracle
1Z0-052 · Question #94
1Z0-052 Question #94: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #94. The question stem and answer options stay visible for context.
Question
Examine the following statement that is used to modify the primary key constraint on the SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE; Which three statements are true regarding the above command? (Choose three.)
Options
- AThe constraint remains valid.
- BThe index on the constraint is dropped.
- CIt allows the loading of data into the table using SQL *Loader.
- DNew data conforms to the constraint, but existing data is not checked.
- EIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
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.