ocp 11g认证考试051题库解析：第49题
来源：优技教育
ocp 11g认证考试051题库解析：第49题，完整题库请点击这里联系老师咨询了解
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用户访问。
精华阅读