OCP-1Z0-新051-61题版本-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.

Answer: D

答案解析：

Create synonym emp for hr.employees是创建一个同义词，该同义词只能在创建的schema里面能访问，

Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a table, view, sequence, operator, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym.

To create a private synonym in your own schema, you must have the  CREATE   SYNONYM  system privilege.

Explanation: