Question 31 :
Describe Oracle database's physical and logical structure ?
Physical : Data files, Redo Log files, Control file.
Logical : Tables, Views, Tablespaces, etc.
Question 32 :
Can you increase the size of a tablespace ? How ?
Yes, by adding datafiles to it.
Question 33 :
What is the use of Control files ?
Contains pointers to locations of various data files, redo log files, etc.
Question 34 :
What is the use of Data Dictionary ?
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 ?
Access time reduced for joins.