One guideline for writing programs for concurrent updates in a PC-based DBMS states that if an update transaction must lock more than one row in the same table, the whole table must be locked.

Question

Quizplus · Accepted Answer

This is known as table-level locking and is a common technique to ensure that concurrent transactions do not modify the same table at the same time. This approach ensures data consistency but may result in decreased concurrency and increased blocking.

One Guideline for Writing Programs for Concurrent Updates in a PC-Based