Q8 /20 Choose the correct description of database rollforward processing.

Rollforward processing is a recovery technique used after a physical failure (such as a system crash or disk failure) to restore the database to a consistent state. It uses the journal file (transaction log) to replay committed transactions that occurred after the last backup was taken, applying them forward to recover lost data. This is performed after the physical failure is detected and the system is restored to a known state.

Step-by-step Derivation:
Rollforward vs. Rollback: Rollforward = redo/replay transactions forward (after failure). Rollback = undo transactions backward (before failure). Physical vs. Logical Failure: Physical failure = hardware crash, disk failure (requires rollforward to restore). Logical failure = incorrect data modifications, accidental deletes (may use rollback or point-in-time recovery). Timeline: Rollforward is applied AFTER the physical failure has been detected and the system restored to the last backup point. Therefore, the correct answer is B.