OCP 1Z0 051 51

51. Which statement is true regarding synonyms? 
A. Synonyms can be created only   for a table. 
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. 

a不对

SQL> select 1 from v where rownum <=1;

         1
----------
         1

已选择 1 行。

已用时间:  00: 00: 00.01
SQL> create or replace view v as select * from dept;

b不对

SQL> create or replace synonym s for sh.sals;

同义词已创建。

c对

SQL> create or replace public synonym dept for dept;

同义词已创建。

d不对

SQL> drop public synonym dept;

同义词已删除。

SQL> select * from dept where rownum <=1;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK

已选择 1 行。

Answer: C