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.
答案:D
解析:题目说oe用户有个orders表,并且将该表的select权限给了hr,使用哪一个create命令可
创建一个ord同义词,hr可以直接通过select * from ord来访问,由于ord前面没有加用户名,所以
只能是创建一个hr用户下的ord同义词,或者创建一个public的同义词,因此
A:错误,创建完后,需要加用户名前缀来访问
B:错误,这里不知道OE有没有权限创建,如果有的话,其实也是正确的,主要是单选,并且还有D选项
C:错误,不是public的,且不是hr创建的
D:正确
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.
答案:D
解析:题目说oe用户有个orders表,并且将该表的select权限给了hr,使用哪一个create命令可
创建一个ord同义词,hr可以直接通过select * from ord来访问,由于ord前面没有加用户名,所以
只能是创建一个hr用户下的ord同义词,或者创建一个public的同义词,因此
A:错误,创建完后,需要加用户名前缀来访问
B:错误,这里不知道OE有没有权限创建,如果有的话,其实也是正确的,主要是单选,并且还有D选项
C:错误,不是public的,且不是hr创建的
D:正确