OCP 11g题库详解：1Z0-051-051题

OCP 11g题库详解：1Z0-051-051题，完整题库请点击这里联系老师咨询了解

51. Which statement is true regarding synonyms?

A. Synonyms can be created only for a table. 不只是表，schema object

B. Synonyms are used to reference only those tables that are owned by another user.

C. A public synonym and a private synonym can exist with the same name for the same table. 共有和私有可以共同存在

D. The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid.

Answer: C

试题解析：

A错误，不只是表，是数据库所有的对象，如表、视图、序列、过程等。

B错误，由数据库管理员创建的公共的同义词，可以所有的用户都可以访问，而由用户自己创建的同义词，只能自己访问。

C正确，共有同义词和私有同义词的名字在一张表中可以相同。

D错误，删除了同义词，但是表不会被变为无效的。