试题详情
单项选择题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;

  • C

  • 关注下方微信公众号，在线模考后查看

热门试题