Set - 10

Question 31 :

Describe Oracle database's physical and logical structure ?

Answer :

Physical : Data files, Redo Log files, Control file.
Logical : Tables, Views, Tablespaces, etc.


Question 32 :

Can you increase the size of a tablespace ? How ?

Answer :

Yes, by adding datafiles to it.


Question 33 :

What is the use of Control files ?

Answer :

Contains pointers to locations of various data files, redo log files, etc.


Question 34 :

What is the use of Data Dictionary ?

Answer :

Used by Oracle to store information about various physical and logical Oracle structures e.g. Tables, Tablespaces, datafiles, etc


Question 35 :

What are the advantages of clusters ?

Answer :

Access time reduced for joins.