Answer the following
1. What are the advantages of Views ?
2. What is a Sequence ?
3. What is a Synonym ?
4. What are the type of Synonyms?
5. What is a Private Synonyms ?
6. What is a Public Synonyms ?
7. What are synonyms used for ?
Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
Hide data complexity.
Simplify commands for the user.
Present the data in a different perpecetive from that of the base table.
Store complex queries.
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
A synonym is an alias for a table, view, sequence or program unit.
There are two types of Synonyms Private and Public.
A Private Synonyms can be accessed only by the owner.
A Public synonyms can be accessed by any user on the database.
Synonyms are used to : 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.
Edited by: keerthi