Question 36 :
What are the types of synonyms?
There are two types of synonyms private and public.
Question 37 :
What is a private synonym?
Only its owner can access a private synonym.
Question 38 :
What is a public synonym?
Any database user can access a public synonym.
Question 39 :
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.
Question 40 :
What is an Oracle index?
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.