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