OCP 11g试题解析：1Z0-051-049题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询OCP 11g试题解析：1Z0-051-049题，完整题库请点击这里联系老师咨询了解
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
试题解析：
题意的问题，要创建一个同义词，使HR用户可以通过SELECT * FROM ord;来查询OE的orders表。
只能由数据库管理员创建公用的同义词，使HR用户来访问。
C创建的私有同义词，因为由DBA用户创建的，所以只能由DBA用户访问。
