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_VUON emp_dept_loc_vu;
B. CREATE PUBLIC SYNONYM EDL:VUFOR mary (emp_dept_loc_vu);
C. CREATE PUBLIC SYNONYM EDL_VUFOR emp_dept_loc_vu;
D. CREATE SYNONYM EDL_VUON emp_dept_loc_vuFOR EACH USER;
E. CREATE SYNONYM EDL_VUFOR EACH USERON emp_dept_loc_vu;
F. CREATE PUBLIC SYNONYM EDL_VUON emp_dept_loc_vuFOR ALL USERS;
|
Download Printable PDF. VALID exam to help you PASS. |
 |