可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

User Mary has a view called EMP_DEPT_L


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
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、A user has no 

A user has no network connectivity. A check of the associated port indicates that&#8194...

2、Mary has a view called EMP_DEPT_LOC_V

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege ...

3、A user has a computer that runs Windo

A user has a computer that runs Windows Vista.You need to prevent the user from accessing contoso.com Web sites.What should you do in Windows Internet Explorer?()AABBCCDD

4、You created a view called EMP_DEPT_VU

You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables:EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTME...

5、A user has written&#

A user has written a script that is not running correctly and asks an administrat...

6、Mary has a view called EMP_DEPT_LOC_VU

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege ...