Set - 1

Question 1 :

What are the components of physical database structure of Oracle database?

Answer :

Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.

Question 2 :

What are the components of logical database structure of Oracle database?

Answer :

There are tablespaces and database's schema objects.

Question 3 :

What is a tablespace?

Answer :

A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.

Question 4 :

What is SYSTEM tablespace and when is it created?

Answer :

Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.

Question 5 :

Explain the relationship among database, tablespace and data file ?

Answer :

Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.