Answer to Question #214281 in Databases | SQL | Oracle | MS Access for Hassam

Question

Given is the details of transaction’s start time and end time. Draw a table which shows what recovery operation will be taken by DBMS at each failure point for each transaction.

i-                  Deferred Updated

Transaction Name Start Time End Time

Ta t₂ t₉

Tb t₁ t₁₁

Tc t₉ t₁₈

Td t₈ t₁₅

Te t₁₄ t₁₉

Failure Points: t7, t10, t13, t20

Check Points: t6, t12, t17

Answer 1

The answer to your question is provided in the image: