Set - 8

Question 6 :

What is a temporary segment?

Answer :

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?

Answer :

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?

Answer :

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?

Answer :

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?

Answer :

The primary function of the redo log is to record all changes made to data.