OCP 1Z0 051 QUESTION NO: 22

来源:互联网 发布:颠覆大数据分析 编辑:程序博客网 时间:2024/06/05 18:53
QUESTION NO: 22 
 
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

与正式题库49重复
http://blog.csdn.net/jgmydsai/article/details/26167987
0 0