What are synonyms used for ?

Answer Posted / nishi

- 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.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain index?

749


What is a static data dictionary in oracle?

572


Can multiple columns be used in group by in oracle?

548


How to define a variable to match a table column data type?

580


Explain the difference between sql and oracle?

582






What is the difference between I and G in Oracle?

603


How to create a table interactively?

562


How to drop a tablespace?

574


What is key preserved table?

567


How to Truncate Table in Oracle

657


What are the limitations oracle database 10g xe?

572


What is data file?

619


Explain the use of show option in imp command.

642


How do I use os authentication with weblogic jdriver for oracle and connection pools?

577


What is a lookup table in oracle?

542