皮皮学，免费搜题
登录
搜题
【单选题】
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?（）A.
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.
B.
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.
C.
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.
D.
Scott 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.
E.
Scott cannot create a synonym because synonyms can be created only for tables.
F.
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.
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
反馈参考答案：
举一反三
【简答题】And miraculously they survived the tsunami because they knew it was________________________.
【简答题】______ people lost their lives in the flood but ______ miraculously survived the wild tide on a piece of wooden flooring.
【简答题】第7章国际贸易货款的收付 案例分析题 1.中东某商人从西欧购买一项商品,买卖双方约定采用信用证付款方式,并明确分两批交货和分两批开立信用证。第一张信用证开出后,已经顺利结汇。第二张信用证开出后,买方因第一批货物质量有问题,向卖方索赔的事尚未了结,便通知银行停止使用其已开出的第二张信用证,但银行仍凭卖方第二批交货的正确单据付了款。当银行通知买方对第二批交货付款赎单时,遭到买方拒付。试分析,买方拒绝...
【单选题】新颖、时尚的产品,购买时不愿作反复的选择比较,最容易受商品的外观、包装、商标或其他促销努力的刺激而产生的购买行为,属于:
A.
习惯型
B.
理智型
C.
经济型
D.
冲动型
相关题目：
参考解析：
知识点：
题目纠错 0
发布
