OCP 1Z0 051 QUESTION NO: 24

QUESTION NO: 24 
 
Examine the statement:
 
Create synonym emp for hr.employees;
  
What happens when you issue the statement?
  
A. An error is generated. 
B. You will have two identical tables in the HR schema with different names. 
C. You create a table called employees in the HR schema based on you EMP table. 
D. You create an alternative name for the employees table in the HR schema in your own schema. 

对于synonym ，可以把它当作windows里的快捷方式理解。
它并不是另建一个表，而是创建了一个指向原表的引用

SQL> Create synonym emp for hr.employees;Synonym created

Answer: D