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

Rollforward processing (also called roll-forward recovery) is a recovery technique that restores a database to a consistent state after a physical failure by replaying committed transactions from a journal/log file after the backup has been restored. This allows the database to recover lost data and reach the point of failure. Rollback (not rollforward) is used for logical failures like incorrect updates.

Step-by-step Derivation:
Rollforward processing occurs in the recovery phase after a physical failure has occurred and a backup has been restored. The steps are: (1) Restore the last backup copy of the database, (2) Read the journal/log file from the point of the backup, (3) Reapply all committed transactions that occurred after the backup was taken. This 'after updating against a physical failure' makes Option B correct. Options A and C are incorrect because they reference 'before updating.' Options C and D incorrectly associate rollforward with logical failures (which use rollback), not physical failures.