Oracle Process Names - Quiz Explanation
The answers you selected are indicated below, along with text that explains the correct answers.
1.
What is the abbreviation of the process that writes modified blocks back to disk?
Please select the best answer.
A.
LGWR
B.
SGA
C.
DBWR
D.
WRTR
The correct answer is C.
The DBWR process is responsible for writing modified database blocks to disk. DBWR is an acronym for
Database Writer
.
2.
What is the abbreviation for the process that writes the redo log files?
Please select the best answer.
A.
LOGW
B.
LGWR
C.
LWRIT
D.
LOGS
The correct answer is B.
The LGWR process is responsible for writing to the redo log files. LGWR is an acronym for Log Writer.
3.
What is the abbreviation for the common memory area that is used by the various background processes?
Please select the best answer.
A.
SHR
B.
COM
C.
SGA
D.
DBA
The correct answer is C.
SGA is an acronym for System Global Area, which is the common memory area shared by the Oracle background processes.