Multiple choice technology databases

What is the minimum number of online redo log files required in a database?

  1. One

  2. Two

  3. Four

  4. Zero

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

An Oracle database requires a minimum of two online redo log groups to function. This is because Oracle writes to them in a circular fashion; while one group is being archived or filled, the database must have another group available to continue writing redo entries without halting operations.