5. a) What is dirty read? b) Are there any dirty reads in the schedule in...

Transcribed Image Text:

5. a) What is dirty read? b) Are there any dirty reads in the schedule in Figure-2? If so, mention which instructions are dirty reads (along with Line Numbers) and explain why they are dirty reads. 1. 2. 3. 4. 5. 16. 7. 8. 19. 10. 11. 12. 13. T1 w(X) w(Y) T2 w(Z) r(X) r(Z) w(P) T3 r(X) w(Y) r(X) Figure-2 T4 r(Y) w(Y) w(X) r(Y) 5. a) What is dirty read? b) Are there any dirty reads in the schedule in Figure-2? If so, mention which instructions are dirty reads (along with Line Numbers) and explain why they are dirty reads. 1. 2. 3. 4. 5. 16. 7. 8. 19. 10. 11. 12. 13. T1 w(X) w(Y) T2 w(Z) r(X) r(Z) w(P) T3 r(X) w(Y) r(X) Figure-2 T4 r(Y) w(Y) w(X) r(Y)

Answer rating: 100% (QA)

A Dirty read also known as writeread conflict is a problem which arises when a transaction reads a v... View the full answer