Instance Architecture   «Prev  Next»

Oracle Instance Architecture - Exercise

Oracle process essay questions

Objective: Answer the essay questions and submit the answers.

Exercise scoring

This exercise is worth a total of twenty-five points. Each correct answer is worth five points. Question two is worth ten points.

Instructions

Answer the following questions and submit the answers.
  1. Why does Oracle not write changes to disk immediately after they are made?
  2. When you commit a transaction, since DBW0 may not have written the changes to disk, how is the completion of that transaction guaranteed in the event of an instance crash?
  3. What does archive log mode provide you?
  4. Why is the Archiver process important? What would happen if the database was in archive log mode, and the Archiver was not running?

Submitting your exercise

Enter your answers into the text box below. Click the Submit button to submit the answers.