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用戶訪問。
