Instance Architecture   «Prev  Next»

Database writer process - Quiz

Select the best answer or answers for each question.
1. Identify the three situations that will trigger the database writer to write.
Please select all the correct answers.
  A. Oracle needs to read data from disk, and there are no free buffers left.
  B. A user has committed a transaction.
  C. The checkpoint needs to be advanced.
  D. The number of dirty blocks exceeds a predefined target.
  E. The DBA issued an ALTER DATABASE WRITE BUFFERS command.
  F. The redo log buffer needs to overflow into the database buffer cache.

2. What does the acronym LRU stand for?
Please select the best answer.
  A. Lock Resource Usage
  B. Least Recently Used
  C. Long Running Units
  D. Log Redo Underflow

3. Why would you limit the number of dirty buffers in the database buffer cache?
Please select the best answer.
  A. To minimize recovery time
  B. To maximize disk I/O
  C. To prevent data corruption
  D. To free up memory