Oracle
1Z0-061 · Question #313
1Z0-061 Question #313: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #313. The question stem and answer options stay visible for context.
Question
There is a simple view SCOTT.DEPT_VIEW on the table SCOTT.DEPT. This insert fails with an error: SQL> insert into dept_view values('SUPPORT','OXFORD'); insert into dept_view values('SUPPORT','OXFORD') * ERROR at line 1: ORA-01400: cannot insert NULL into ("SCOTT"."DEPT"."DEPTNO") What might be the problem? (Choose the best answer.)
Options
- AThere is a NOT NULL or PRIMARY KEY constraint on DEPT.DEPTNO.
- BThe INSERT violates a constraint on the view.
- CThe view was created as WITH READ ONLY.
- DThe view was created as WITH CHECK OPTION.
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.