Which DBMS mechanism allows multiple transactions to access shared data safely without interfering with one another?

Options

  • A. Concurrency control
  • B. Data loading
  • C. File compression
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. Concurrency control

Detailed Explanation

  • Concurrency control: Coordinates simultaneous transactions accessing shared data.
  • It helps prevent problems such as lost updates and inconsistent reads.
  • Locking and timestamp ordering are common concurrency control techniques.