Oracle
1Z0-061 · Question #312
1Z0-061 Question #312: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #312. The question stem and answer options stay visible for context.
Question
Study this view creation statement: create view dept30 as select department_id,employee_id,last_name from employees where department_id=30 with check option; What might make the following statement fail? (Choose the best answer.) update dept30 set department_id=10 where employee_id=114;
Options
- AUnless specified otherwise, views will be created as WITH READ ONLY.
- BThe view is too complex to allow DML operations.
- CThe WITH CHECK OPTION will prevent DML that would cause a row to disappear from the
- DThe statement will succeed.
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 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.