Computer Science: An Overview: Global Edition (12th Edition)

Published by Pearson Higher Education
ISBN 10: 1292061162
ISBN 13: 978-1-29206-116-0

Chapter 9 - Database Systems - Chapter Review Problems - Page 454: 45

Answer

See the explanation

Work Step by Step

If T1 is the younger transaction in the wound-wait protocol, it would result in T1 being rolled back if it tries to access a data item locked by an older transaction (T2). This ensures consistency in the transaction sequence. If T2 is the younger transaction, it can wait for the lock held by T1 without causing a rollback, allowing for a more flexible execution order.
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.