Set - 1

Question 36 :

What are the types of synonyms?

Answer :

There are two types of synonyms private and public.


Question 37 :

What is a private synonym?

Answer :

Only its owner can access a private synonym.


Question 38 :

What is a public synonym?

Answer :

Any database user can access a public synonym.


Question 39 :

What are synonyms used for?

Answer :

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


Question 40 :

What is an Oracle index?

Answer :

An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.