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...

Assessment: WAEC SSCE - Data Processing - 2017 (Objective) Subject: Data Processing

Question 1 Report

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.

Download The App On Google Playstore

Everything you need to excel in your exams

Green Bridge CBT Mobile App
Personalized AI Learning Chat Assistant
200,000+ Exam Questions Across IGCSE, JAMB, WAEC & NECO
Over 3,900 Lesson Notes
Offline Support - Learn Anytime, Anywhere
Green Bridge Timetable
Literature Summaries & Potential Questions
Track Your Performance & Progress
In-depth Explanations for Comprehensive Learning