本文介绍如何使用CREATE SYNONYM语句来为Oracle数据库中的表、视图等对象创建同义词，这是一种替代名称，便于在自己的模式中访问其他模式的对象。
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:
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
