Oracle Exam 1Z0-061 Topic 2 Question 5 Discussion

Actual exam question for Oracle's 1Z0-061 exam

Question #: 5
Topic #: 2

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?

AThe INSERT violates a constraint on the detail table.

BThe INSERT violates a constraint on the view.

CThe view was created as WITH READ ONLY.

DThe view was created as WITH CHECK OPTION.

Show Suggested Answer

Suggested Answer: A

B is incorrect because constraints are enforced on detail tables, not on views. C and D are incorrect because the error message would be different.

by Louvenia at Jun 16, 2022, 04:31 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!