Which statement would create a synonym ORD so that HR can execute the following query successfully?

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;

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.



Leave a Reply 0

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