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.
You might also like to view...
An attribute is some characteristic of a(n):
A) entity. B) relationship. C) reality. D) record definition.
Middleware can be seen as representing the slash in the term client/server.
Answer the following statement true (T) or false (F)
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
A file with permissions of crw-rw-r-- is a character device file.
a. true b. false