ocp 11G 49题

k_scott

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?
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.
Answer: D

ORDER是OE的表，OE授权查询ORDERS给HR。
哪个语句能可以创建同义词ORD，以便select *  from ord能成功执行？
我觉得B 用OE创建公共同义词ORDfor orders。然后HR执行select *  from ord不也可以吗。

k_scott

没人帮忙回答

LuiseDalian

每个老师的时间安排会不同，我会每天早上6：30-7：30之间来回答（因为白天没有大块的空闲时间）
B，错误，原因，OE没有权限创建公有同义词。

k_scott

LuiseDalian 发表于 2013-4-26 07:16
每个老师的时间安排会不同，我会每天早上6：30-7：30之间来回答（因为白天没有大块的空闲时间）
B，错误， ...

哦。多谢。老师