1Z0-061 · Question #312
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…
The correct answer is C. The WITH CHECK OPTION will prevent DML that would cause a row to disappear from the. A, B, D. A is wrong because views are by default created read/write. B is wrong because the view is a simple view. D is wrong because the statement cannot succeed because the check option will reject it.
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.
How the community answered
(70 responses)- A4% (3)
- B11% (8)
- C79% (55)
- D6% (4)
Explanation
A, B, D. A is wrong because views are by default created read/write. B is wrong because the view is a simple view. D is wrong because the statement cannot succeed because the check option will reject it.
Topics
Community Discussion
No community discussion yet for this question.