Instance Architecture   «Prev  Next»

Oracle Database Writer - Quiz

Each question is worth one point. Select the best answer for each question.
1. What is the primary responsibility of an Oracle Database Writer process?
Please select the best answer.
  A. Write redo entries to online redo log files.
  B. Write modified blocks from the database buffer cache to datafiles.
  C. Register database services with the listener.
  D. Execute scheduled PL/SQL jobs.

2. What is the documented maximum number of Database Writer processes for an Oracle 26ai instance?
Please select the best answer.
  A. An unlimited number.
  B. One.
  C. Ten.
  D. One hundred.

3. Which initialization parameter specifies the initial number of Database Writer processes for an instance?
Please select the best answer.
  A. DB_WRITER_PROCESSES
  B. DATABASE_WRITER_MAX
  C. DBWR_PROCESSES
  D. DBW_PROCESS_COUNT

4. For a normal synchronous COMMIT, must Database Writer write every block changed by the transaction to datafiles before success is returned?
Please select the best answer.
  A. Yes. Every changed block must be written before the commit completes.
  B. No. The required redo is persisted, while changed blocks can be written later.
  C. No. Committed changes never need to be written to datafiles.
  D. Yes. The archiver must write the changed blocks first.

5. Before Database Writer writes a dirty buffer to a datafile, what must happen to the redo records associated with its changes?
Please select the best answer.
  A. They must be discarded from memory.
  B. They must be copied into the control file.
  C. They must be written to the online redo log.
  D. They must be archived before the block can be written.