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.