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

You might also like to view...

Use the Shift key to select noncontiguous slides

Indicate whether the statement is true or false

Computer Science & Information Technology

The extension name of a Java source code file is

a. .java b. .obj c. .class d. .exe

Computer Science & Information Technology