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 to create a public synonym, and would like to create a synonym for this view that can be used by all users of the
题目
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 to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database. Which SQL statement can Mary use to accomplish that task?（）
A. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu
B. CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
C. CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;
D. CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
E. CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu
F. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;
相似考题
更多“User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPAR ”相关问题
-
第1题：
Diameter路由代理(DRA)在Sh接口支持基于哪个AVP进行寻址?A.Destination-Host
B.Public-Identity
C.User-Name
D.Called-Station-Id
E.Framed-IPv6-Address
参考答案：A
-
第2题：
下面程序段执行完毕，页面显示的内容是（）。 string strName; strName = "user_name"; Session["strName"] = "Mary"; Session[strName] = "John"; Response.Write（Session["user_name"]);
A．Mary
B．John
C．user_name
D．语法有错，无法正常运行
错误信息 -
第3题：
在用户视图下键入什么命令可以切换到系统视图？
A．system-view
B．interface
C．quit
D．user-view
quit -
第4题：
华为交换机在系统视图下键入什么命令可以切换到用户视图（ ）。A.system-view
B.router
C.quit
D.user-view答案：C解析：*输入quit命令可以从系统视图退出到用户视图。 -
第5题：
3、Toast创建完毕后，需要显示出来此时需要调用以下哪个方法？（）
A．makeText
B．show
C．create
D．view
show -
第6题：
Toast对象创建后，需要显示出来此时需要调用以下哪个方法？（）
A．makeText
B．show
C．create
D．view
show