Oracle
1Z0-061 · Question #316
1Z0-061 Question #316: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #316. The question stem and answer options stay visible for context.
Question
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.)
Options
- AThere will not be an error because the synonym addresses the view, which still exists, but there
- BThere will not be an error if you first recompile the view with the command ALTER VIEW DEPT_V
- 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
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.