When a database recovery manager is invoked after a crash, restart proceeds in the following three phases; I. Undo II. Redo III. Analysis. Arrange these pha...

When a database recovery manager is invoked after a crash, restart proceeds in the following three phases; I. Undo II. Redo III. Analysis. Arrange these phases in the right order.

Answer Details

The correct order of the phases when a database recovery manager is invoked after a crash is: I. Analysis - where the recovery manager examines the log to determine which transactions were incomplete at the time of the crash and which updates were made by these transactions before the crash. II. Redo - where the recovery manager applies the updates that were made by incomplete transactions before the crash and updates the database to reflect these changes. III. Undo - where the recovery manager rolls back transactions that were incomplete at the time of the crash and undoes the updates made by these transactions. Therefore, the correct order is III, II, I.