User Mary has a view called EMP_DEPT_LOC_VU that was created based on theEMPLOYEES, DEPARTMENTS, and LOCATIONS tables. S
Posted: Wed Jun 07, 2023 6:12 am
User Mary has a view called EMP_DEPT_LOC_VU that was created based on theEMPLOYEES, 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;
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;