Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Question

Quizplus · Accepted Answer

Locking is a technique used to control and coordinate the access of multiple users or processes to shared resources, such as files or database records, to prevent them from interfering with each other and to ensure consistency and integrity of the data. One of the main problems that locking tries to solve is the lost-update problem, which occurs when two or more users try to update the same data concurrently, and one of the updates overwrites or cancels out the other, leading to inconsistent or incorrect results. By using locking, each user can acquire exclusive or shared access to the data, and release it only after completing their transaction or operation, thus preventing conflicts and preserving atomicity, consistency, isolation, and durability (ACID) properties of the database. Therefore, the statement is true.

Locking Must Be Used to Coordinate the Activities of Users