单选题
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_DEP_LOC_VU each time the view is referenced? （）
发布日期：2020-04-10
Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn.
Scott 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.
Scott 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.
Scott cannot create a synonym because synonyms can be created only for tables.
Scott 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.
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
按《环境管理体系要求及使用指南》GB/T24001—2016，在体系标准的总体结构中属于“支持”的内容有（）。
在主体部位传热系数检测结束后进行数据分析时以下那种说法不正确（）
今年应是119消防宣传日的届数是（）
非定额时间
中枢淋巴器官的主要特征是：（）。
对易燃易爆化学物品经营单位扩建工程竣工时未经消防验收或者经验收不合格擅自使用的，经公安消防机构责令限期改正后逾期不改的，应当（）。
办理“对公转账业务”的业务大类，贷方账户不得为（）。
彭祖养生文化的精髓是什么？
从1989年发表开始，刘震云发表了“官场”系列小说，主要有（）等。
甲、乙、丙类厂房设有自动灭火系统时，防火分区最大允许占地面积，可在相关规定的基础上增加（ ）倍。
暂无相关推荐~
User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOY...
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES,D...
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, ...
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, ...
User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOY...
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, ...
You created a view called EMP_DEPT_VU that contains three columns from the EMPLO...
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your ...
You created a view called EMP_DEPT_VU that contains three columns from the EMPLO...
You created a view called EMP_DEPT_VU that contains three columns from the EMPLO...