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.)

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.)

Accepted Answer

D. There will be an error because the view will be invalid.

Answer

A. There will not be an error because the synonym addresses the view, which still exists, but there

Answer

B. There will not be an error if you first recompile the view with the command ALTER VIEW DEPT_V

Answer

C. There will be an error because the synonym will be invalid.

Answer

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

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…

Question

Options

How the community answered

Community Discussion