Multiple choice

Locking can be used for

  1. deadlock

  2. lost update

  3. uncommitted dependency

  4. inconsistent data
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

Locking protocols prevent concurrent transaction problems: lost updates (overwriting uncommitted changes), uncommitted dependencies (reading dirty data), and inconsistent data (reading partially updated records). Locking ensures transaction isolation and serializability by controlling access to shared data items.

Keep practicing — related questions