Oracle Exam 1Z0-061 Topic 2 Question 2 Discussion

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

Question #: 2
Topic #: 2

A view and a synonym are created as follows:

create view dept_v as select * from dept; create synonym dept_s for dept_v; Subsequently the table DEPT is dropped.

What will happen if you query the synonym DEPT_S ? (Choose the best answer.)

AThere will not be an error because the synonym addresses the view, which still exists, but there will beno rows returned.

BThere will not be an error if you first recompile the view with the command ALTER VIEW DEPT_VCOMPILE FORCE;

CThere will be an error because the synonym will be invalid.

DThere will be an error because the view will be invalid.

EThere will be an error because the view will have been dropped implicitly when the table was dropped.

Show Suggested Answer

Suggested Answer: D

The synonym will be fine, but the view will be invalid. Oracle will attempt to recompile the view, but this will fail.

by Lai at Jun 14, 2022, 11:55 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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