What is concurrency control and why does a DBMS need a concurrency control facility?
What will be an ideal response?
A mechanism to ensure that the database is updated correctly when multiple users are
updating the database concurrently.
This avoids inconsistencies from arising when two or more transactions are executing and at
least one is updating the database.
Computer Science & Information Technology