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;
B.
CREATE PUBLIC SYNONYM EDL:VU
FOR mary (emp_dept_loc_vu);
C.
CREATE PUBLIC SYNONYM EDL_VU
FOR emp_dept_loc_vu;
D.
CREATE SYNONYM EDL_VU
ON emp_dept_loc_vu
FOR EACH USER;
E.
CREATE SYNONYM EDL_VU
FOR EACH USER
ON emp_dept_loc_vu;
F.
CREATE PUBLIC SYNONYM EDL_VU
ON emp_dept_loc_vu
FOR ALL USERS;
Explanation:
The general syntax to create a synonym is:
CREATE [PUBLIC] SYNONYM synonym FOR object;