OCP-1Z0-051-V9.02-49题
来源:互联网 发布:java为app接口开发实例 编辑:程序博客网 时间:2024/06/08 15:58
49. The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS
table to the user HR.
Which statement would create a synonym ORD so that HR can execute the following query successfully?
SELECT * FROM ord;
A. CREATE SYNONYM ord FOR orders; This command is issued by OE.
B. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE.
C. CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator.
D. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator.
Answer: D
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12781353
题意的问题,要创建一个同义词,使HR用户可以通过SELECT * FROM ord;来查询OE的orders表。
只能由数据库管理员创建公用的同义词,使HR用户来访问。
C创建的私有同义词,因为由DBA用户创建的,所以只能由DBA用户访问。
- OCP-1Z0-051-V9.02-49题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-11题
- OCP-1Z0-051-V9.02-12题
- OCP-1Z0-051-V9.02-14题
- OCP-1Z0-051-V9.02-15题
- OCP-1Z0-051-V9.02-17题
- OCP-1Z0-051-V9.02-18题
- OCP-1Z0-051-V9.02-21题
- OCP-1Z0-051-V9.02-118题
- OCP-1Z0-051-V9.02-120题
- OCP-1Z0-051-V9.02-32题
- OCP-1Z0-051-V9.02-33题
- OCP-1Z0-051-V9.02-93题
- OCP-1Z0-051-V9.02-94题
- OCP-1Z0-051-V9.02-95题
- jquery ui的autocomplete在ie6下不能遮盖select
- 小知识汇总
- SITTC教你云计算基础知识入门(九)
- SITTC教你云计算基础知识入门(十)
- 多余文字变省略号
- OCP-1Z0-051-V9.02-49题
- Some simple c program
- C#图片上传展现代码(含部分DNN代码)
- 如何在ant脚本中获取svn版本号
- SITTC教你云计算基础知识入门(十一)
- 百度地图api android sdk leaked ServiceConnection com.baidu.location.LocationClient错误
- CVS的使用(多数人认为cvs已经老了,不过本人还是想了解一下)
- 超链接,根据条件使得超链接显示与否
- SITTC教你云计算基础知识入门(十二)