Question 6 :
What is a temporary segment?
Temporary segments are created by Oracle when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.
Question 7 :
What is a datafile?
Every Oracle database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.
Question 8 :
What are the characteristics of data files?
A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.
Question 9 :
What is a redo log?
The set of redo log files for a database is collectively known as the database redo log.
Question 10 :
What is the function of redo log?
The primary function of the redo log is to record all changes made to data.