Set - 1

Question 31 :

What is Table ?

Answer :

A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.


Question 32 :

Can a view based on another view?

Answer :

Yes.


Question 33 :

What are the advantages of views?

Answer :

- 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 perspective from that of the base table.
- Store complex queries.


Question 34 :

What is an Oracle sequence?

Answer :

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


Question 35 :

What is a synonym?

Answer :

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