当前位置:1Z0-007题库

问题:

[单选] 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?()

A . Scott 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.
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.

慢性失眠症的治疗包括() 强调定时作息、规律生活。 睡前避免兴奋和紧张的脑力及体力活动。 心理治疗的放松治疗可减轻对睡眠的焦虑。 避免饮用浓茶、咖啡等易引起兴奋的物质。 合理使用镇静安眠药物。 研究幼儿园管理的常用方法,主要有以下几种() A.调查法 。 B.文献法 。 C.实验法 。 D.案例法。 第二代中枢性降血压药如莫索尼定药理作用及降压特点与第一代中枢性降压药如可乐定比,错误的是() 对咪唑啉I1受体的选择性比可乐定高。 降压效能比可乐定高。 不良反应比可乐定少。 无停药反跳现象。 对α2受体作用较可乐定弱。 对管理人员的考评是由被考评者的直接上级进行的。 精馏中雾沫夹带的含义是什么?操作中控制的标准是什么? 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?()
参考答案:

  参考解析

本题暂无解析

在线 客服