Prev Question
Next Question

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.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *