What is the primary goal of concurrency control in DBMS?
2025
What is the primary goal of concurrency control in DBMS?
- A.
To ensure that multiple transactions can execute concurrently without violating database consistency
- B.
To speed up database queries by allowing transactions to overlap
- C.
To allow only one transaction to be executed at a time
- D.
To guarantee that all transactions will complete anyhow
Attempted by 83 students.
Show answer & explanation
Correct answer: A
The primary goal of concurrency control in DBMS is to maintain data consistency and integrity during simultaneous transaction execution. It prevents anomalies such as lost updates, dirty reads, and unrepeatable reads.