（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?（choose two)

SELECT * FROM ord;

A. This command is issued by OE.

CREATE SYNONYM ord FOR orders;

B. This command is issued by OE.

CREATE PUBLIC SYNONYM ord FOR orders;

C. This command is issued by the database administrator.

CREATE SYNONYM ord FOR oe.orders;

D. This command is issued by the database administrator.

CREATE PUBLIC SYNONYM ord FOR oe.orders;

答案：（B, D）

--B

oe@TESTDB11>grant select on orders to hr;

Grant succeeded.

sys@TESTDB11>grant create public synonym to oe;

Grant succeeded.

oe@TESTDB11>create public synonym ord for orders;

Synonym created.

hr@TESTDB11>select count(*) from ord;

COUNT(*)

----------

105

--E

public@TESTDB11>drop synonym ord;

Synonym dropped.

sys@TESTDB11>create public synonym ord for oe.orders;

Synonym created.

hr@TESTDB11>select count(*) from ord;

COUNT(*)

----------

105

ITPub博客

OCP 1Z0-051-49