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...

Middleware can be seen as representing the slash in the term client/server.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

If you want to ensure that a user enters numeric data, you should use ____ techniques that provide the means for your program to recover from the mistake.

A. error-handling B. looping C. exception-handling D. decision

Computer Science & Information Technology

A file with permissions of crw-rw-r-- is a character device file.

a. true b. false

Computer Science & Information Technology

An attribute is some characteristic of a(n):

A) entity. B) relationship. C) reality. D) record definition.

Computer Science & Information Technology