多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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;
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题