Which SQL statement can Mary use to accomplish that task?

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the
EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a
public synonym, and would like to create a synonym for this view that can be used by all
users of the database. Which SQL statement can Mary use to accomplish that task?

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the
EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a
public synonym, and would like to create a synonym for this view that can be used by all
users of the database. Which SQL statement can Mary use to accomplish that task?

A.
CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

B.
CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu;

C.
CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;

D.
CREATE PUBLIC SYNONYM EDL_VU FOR emp_dept_loc_vu;

E.
CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu;

F.
CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);



Leave a Reply 1

Your email address will not be published. Required fields are marked *


luca

luca

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm

Specify PUBLIC to create a public synonym. Public synonyms are accessible to all users. However each user must have appropriate privileges on the underlying object in order to use the synonym.

A is not right,
FOR Clause

Specify the object for which the synonym is created. The schema object for which you are creating the synonym can be of the following types:

CREATE PUBLIC SYNONYM emp_table
FOR hr.employees