OCP 1Z0 051 49

tonwei139

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.



synonym只有public可以被所有用户访问。否则就只能访问本用户创建的

SYS >conn oe/oe
已连接。
OE >grant select on orders to hr;
授权成功。
OE >create or replace synonym ord for orders;
同义词已创建。
OE >conn hr/hr
已连接。
HR >select * from ord where rownum <=1;
select * from ord where rownum <=1
*
第 1 行出现错误:
ORA-00942: 表或视图不存在

OE >create or replace public synonym ord for orders;
同义词已创建。
已用时间:  00: 00: 00.01
OE >conn hr/hr
已连接。
HR >select ORDER_id from ord where rownum <=1;
ORDER_ID
----------
2354
已选择 1 行。
已用时间:  00: 00: 00.00
HR >

SYS >create or replace  synonym ord for oe.orders;
同义词已创建。
已用时间:  00: 00: 00.00
SYS >conn hr/hr
已连接。
HR >select * from ord where rownum <=1;
select * from ord where rownum <=1
*
第 1 行出现错误:
ORA-00942: 表或视图不存在


SYS >create or replace public synonym ord for oe.orders;
同义词已创建。
已用时间:  00: 00: 00.09
SYS >conn hr/hr;
已连接。
HR >select ORDER_id from ord where rownum <=1;
ORDER_ID
----------
2354

Answer: 应为B D

版权声明：本文为博主原创文章，未经博主允许不得转载。