皮皮学，免费搜题
登录
搜题
【单选题】
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.
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【简答题】高中化学新课程的特点
【多选题】以下各项中,反映联合杠杆作用的有:
A.
说明普通股每股收益的变动幅度
B.
预测普通股每股收益
C.
衡量企业的总体风险
D.
说明企业财务状况
E.
反映企业的获利能力
【单选题】盆腔炎性疾病的治疗不正确的是（）
A.
采取血、尿、宫颈管分泌物和盆腔脓液等标本做培养及药敏试验
B.
发热等感染症状明显者，应全身应用抗菌药物
C.
盆腔炎症大多为需氧菌和厌氧菌混合感染，应使用能覆盖常见需氧和厌氧病原菌的抗菌药物。病原检查获阳性结果后依据药敏试验结果调整用药
D.
抗菌药物的剂量应足够，疗程宜较长，以免病情反复发作或转成慢性。初始治疗时宜口服给药；必要时可改为静脉给药