Oracle
1Z0-047 · Question #114
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…
The correct answer is D. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator. See the full explanation below for the reasoning.
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;
Options
- ACREATE SYNONYM ord FOR orders; This command is issued by OE.
- BCREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE.
- CCREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator.
- DCREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator.
How the community answered
(29 responses)- A3% (1)
- B7% (2)
- C14% (4)
- D76% (22)
Community Discussion
No community discussion yet for this question.