Oracle Contest-3 with answers

[keerthi]

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 ?

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

2.
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

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

4.
There are two types of Synonyms Private and Public.

5.
A Private Synonyms can be accessed only by the owner.

6.
A Public synonyms can be accessed by any user on the database.

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

[madhab]

1.View provides an additional logical abstraction to the data base where it hides the complexity the the data base.

It prevents to access to the rows and columns of the database.

It presents the data according to user's request and meaning ful to a paricular operation.

2.

A sequenceis a serial list of unique numbers for numerical columns of a database's tables.

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

4. There are two types of Synonyms ---> Private and Public.

5. A Private synonym is what can be accessed only by the owner.

6. A Public synonyms can be accessed by any user on the database.

7.Synonyms r used to mask the real name of the object -apart from this it provides public and private access o the objects.

It sipmlify the SQL statement for the USER.

[sowmya571]

Hi



1. What are the advantages of Views ?



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.



Simply put A VIEW IS LOGICAL DATA SOURCE USED TO STORE DATA , I STEAD OF GIVG PERMISIOn on Table on all the data u store ibn a view and give permissiobn

to that one

[sowmya571]

hello



2. What is a Sequence ?




A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

[sowmya571]

hello



3. What is a Synonym ?




A synonym is an alias for a table, view, sequence or program unit.
Its is another name for a table or object

[sowmya571]

hello



What are the type of Synonyms?




There are two types of Synonyms Private and Public.

[sowmya571]

hello



. What is a Private Synonyms ?

A Private Synonyms can be accessed only by the owner.



6. What is a Public Synonyms ?



A Public synonyms can be accessed by any user on the database.

[sowmya571]

hello



7. What are synonyms used for ?




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.