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

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 to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY.EMP_DEPT_LOC_VU each time the view is referenced?()

  • AScott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.
  • BScott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.
  • CScott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.
  • DScott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym.
  • EScott cannot create a synonym because synonyms can be created only for tables.
  • FScott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、6.Mary has _______day today.

6.Mary has _______day today.A really a busyB a busy reallyC a really busyD a real busy

2、Kate is a little()than Mary.

Kate is a little()than Mary.AyoungerByoungCthe youngestDyoungest

3、设S=“A;/document/Mary.doc”,则strlen(s)=(

设S=“A;/document/Mary.doc”,则strlen(s)=(),“/”的字符定位的位置为()。

4、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 t...

5、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 ...

6、()has been called the “cradle of Ameri

()has been called the “cradle of American Liberty”.APhiladelphiaBPlymouthCBosto