ocp 11g題庫詳解：1Z0-051-051題，完整題庫請(qǐng)點(diǎn)擊這里聯(lián)系老師咨詢了解

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錯(cuò)誤，不只是表，是數(shù)據(jù)庫所有的對(duì)象，如表、視圖、序列、過程等。

B錯(cuò)誤，由數(shù)據(jù)庫管理員創(chuàng)建的公共的同義詞，可以所有的用戶都可以訪問，而由用戶自己創(chuàng)建的同義詞，只能自己訪問。

C正確，共有同義詞和私有同義詞的名字在一張表中可以相同。

D錯(cuò)誤，刪除了同義詞，但是表不會(huì)被變?yōu)闊o效的。