Database Management Systems · End Term · 13 Apr 2025 · January 2025 term · Set QDD3

Question 18: Consider the given log records at an instance of time: T…

Question 18

+3 marksNumerical answer

Consider the given log records at an instance of time:

Table 3: Log records

$< T_0 \text{ start} >$
$< T_0, A, 500, 600 >$
$< T_1 \text{ start} >$
$< T_1, B, 800, 700 >$
$< T_0, C, 400, 900 >$
$< T_2 \text{ start} >$
$< T_2, D, 1000, 200 >$
$< Commit\ T_0 >$
$< Checkpoint\ L >$
$< T_2, C, 400, 1000 >$
$< T_1, A, 500, 300 >$
$< Commit\ T_2 >$
$< T_1, D, 1000, 450 >$

Suppose there is a system crash after the last log record. What will be the value of the expression (A+B+C-D), based on the values stored on the disk at that point?

Show answer

Correct answer: 2200

See the whole paper Take it as a mock test

Question 18 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 13 Apr 2025, in the January 2025 term (IIT M DIPLOMA AN EXAM QDD3 13 Apr 2025). It carries 3 marks.

Question 18: Consider the given log records at an instance of time: T…

Question 18

More questions from this paper