Question 31 :
What is Table ?
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?
Question 33 :
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 perspective from that of the base table.
- Store complex queries.
Question 34 :
What is an Oracle sequence?
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
Question 35 :
What is a synonym?
A synonym is an alias for a table, view, sequence or program unit.