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_vuB. 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_vuF. 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, 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;


相关考题:

进入系统视图模式的命令是() A. Ctrl+ZB.Ctrl+]C.system-viewD.user-view

在系统视图下键入什么命令可以切换到用户视图?() A.system-viewB.routerC.quitD.user-view

Diameter路由代理(DRA)在Cx接口支持基于哪个AVP进行寻址? A.User-NameB.Public-IdentityC.Called-Station-IdD.User-IdentityE.Framed-IPv6-Address

Diameter路由代理(DRA)在Zh接口支持基于哪个AVP进行寻址? A.Destination-HostB.User-NameC.Called-Station-IdD.User-IdentityE.Framed-IPv6-Address

Diameter路由代理(DRA)在Sh接口支持基于哪个AVP进行寻址? A.Destination-HostB.Public-IdentityC.User-NameD.Called-Station-IdE.Framed-IPv6-Address

华为交换机在系统视图下键入什么命令可以切换到用户视图( )。A.system-viewB.routerC.quitD.user-view

下面程序段执行完毕,页面显示的内容是()。 string strName; strName = "user_name"; Session["strName"] = "Mary"; Session[strName] = "John"; Response.Write(Session["user_name"]);A.MaryB.JohnC.user_nameD.语法有错,无法正常运行

3、Toast创建完毕后,需要显示出来此时需要调用以下哪个方法?()A.makeText  B.show    C.create   D.view

在用户视图下键入什么命令可以切换到系统视图?A.system-viewB.interfaceC.quitD.user-view

Toast对象创建后,需要显示出来此时需要调用以下哪个方法?()A.makeTextB.showC.createD.view