SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.
SQL tutorial | Interview questions | Oracle

Database administration, oracle Interview questions, SQL Interview questions, DBMS Interview questions,SQL tutorial


What is a synonym

SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions

Go down

What is a synonym Empty What is a synonym

Post by Micheal Wed Jan 20, 2010 11:07 pm

What is a synonym?
A synonym is an alias for a table, view, sequence or program unit.

What are the types of synonyms?
There are two types of synonyms private and public.

What is a private synonym?
Only its owner can access a private synonym.

What is a public synonym?
Any database user can access a public synonym.

What are synonyms used for?
- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions

 
Permissions in this forum:
You cannot reply to topics in this forum