Multiple choice

In a multi-user database, if two users wish to update the same record at the same time, they are prevented by

  1. jamming

  2. password

  3. documentation

  4. record lock

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When multiple users try to update the same record simultaneously, record locking prevents conflicts by ensuring only one transaction can modify the record at a time. This concurrency control mechanism prevents the lost update problem where two updates overwrite each other. Locking maintains data integrity and consistency in multi-user database environments.