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.
OOps! You are currently offline.