Multiple choice technology databases

In oracle 10g, which statement regarding the usage of redo log file during instance recovery is true?

  1. Transactions are rolled back using redo log files.

  2. Transactions are rolled forward using redo log files.

  3. Transactions are rolled back using redo log files and archived log files.

  4. Transactions are rolled forward using redo log files and rolled back using redo log files
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

During instance recovery, Oracle uses redo log files to roll forward (reapply) all committed and uncommitted changes. Uncommitted transactions are subsequently rolled back using undo data, not redo logs.

Keep practicing — related questions