移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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

User Mary has a view called EMP_DEPT_LOC_VU that w...
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;

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

CMS专题

CMS专题

去刷题
热门试题热门资讯 相关试题

暂无相关推荐~