Question $3(4$ points$)$

Consider a DBMS using write$-$ahead logging with the STEAL and NO$-$FORCE buffer pool management policy. The log contains update records, checkpoints, and transaction begin$/$commit$/$abort records. Assume the DBMS executes a non$-$fuzzy checkpoint, where all dirty pages are written to disk. Its update record has the following form:

Assume the DBMS uses the ARIES recovery protocol. The database has three transactions $($T$1,$ T$2,$ T$3)$ on three data objects $($A$,$ B$,$ C$).$ The following table shows the log records available on disk after a crash:

LSN WAL Record

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$10$

$11$

$12$

$13$

$14$

$15$

What are the values of A$,$ B$,$ and C stored on disk before the DBMS starts to recover the state of the database?

Question $3$ options:

A$=71,$ B$=6,$ C$=100$

A$=13,$ B$=66,$ C$=67$

A$=43,$ B$=7,$ C Not sure

A$=71,$ B$=42,$ C$=42$

A:Not sure, B$=20,$ C$=43$

A$=43,$ B$=20,$ C: Not sure

A:Not sure, B:Not sure, C$=67$

A:Not sure, B$=20,$ C:Not sure

A$=71,$ B: Not sure, C$=42$

A$,$B$,$C:Not sure