In the following schedules,
$R_{x} (Z) denotes Trans X Reads item$
$Z, W_{x} (Z) denotes Trans X writes item Z.$

Consider the following schedules:
$S_{1} : R_{1} (A), W_{1} (A), R_{2} (A), W_{2} (A), Commit T_{2}, R_{1} (B), W_{1} (B$

$S_{2} : R_{1} (A), R_{2} (A), W_{2} (A), Commit T_{2}, R_{1} (A), W_{1} (A), Commit$

$S_{3} : R_{2} (A), R_{1} (A), W_{1} (A), W_{2} (A), W_{2} (B) Commit T_{2}, W_{1} (B)$

Which of the following statements are true?

S c h e d u l e S_{1} has dirty read problem.

Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses

S c h e d u l e S_{2} has non-repeatable read problem.

Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses

S c h e d u l e S_{3} has lost update problem

Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses

S c h e d u l e S_{3} is conflict serializable

No worries! We‘ve got your back. Try BYJU‘S free classes today!

Open in App

Solution

The correct option is C $S c h e d u l e S_{3} has lost update problem$
Option (a,b,c)

Suggest Corrections

Similar questions

S : R_{1} (A), R_{3} (B), W_{1} (A), W_{2} (A), W_{2} (B), W_{3} (B)

S : W_{4} (E), R_{1} (C), R_{3} (A), R_{1} (E), W_{2} (A), R_{4} (A), W_{3} (A), R_{3} (B), W_{4} (A), W_{2} (D), W_{1} (A), R_{4} (C), W_{1} (B), R_{4} (D)

S : R_{1} (A), R_{4} (B), W_{3} (A), W_{2} (B), W_{4} (C), c o m m i t_{4}, W_{3} (C), W_{1} (A), c o m m i t 1, R_{2} (D), W_{3} (D),

Join BYJU'S Learning Program