OCP-1Z0-051 第49题 SYNONYM同义词

一、原题

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.

答案：D

二、题目翻译

ORDERS表属于OE用户.OE把ORDERS表的SELECT权限授予HR用户。
下面哪个语句创建了一个ORD同义词，以便HR能成功执行下面这个查询？

三、题目解析

A和C选项，都不正确，因为都创建了一个私有同义词，其它用户不能访问。
B选项，描述不完整，因为题中没有提到OE用户有CREATE PUBLIC SYNONYM的权限，如果有，就是正确的，如果没有则提示权限不足不能建立。