User Mary has a view called EMP_DEPT_LOC_VU that w...
单选题

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?()

发布日期:2020-04-10

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;

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定