OCP-1Z0-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 


题意是要创建一个OE.ORDERS表的同义词，使得HR用户可以使用SELECT * FROM ord;访问OE.ORDERS表，通过题意可知这个同义词应该是DBA创建的公有同义词，所以答案是D