1.

What do you mean by concurrency control?

Answer»

Concurrency Control in a Database MANAGEMENT System is a method of CONTROLLING multiple operations at the same time without interfering. It ensures that Database transactions are completed in a timely and accurate manner to deliver accurate results without jeopardizing the database's data integrity.

The concurrency control mechanism is used by DBMS for the following reasons:

  • ISOLATION is achieved by reciprocal exclusion of conflicting transactions.
  • Conflicts between read-write and write-write must be resolved.
  • Constantly preserving execution obstacles in order to maintain database consistency
  • The system must keep TRACK of how the concurrent transactions interact. Concurrent-control techniques are used to ACHIEVE this control.
     


Discussion

No Comment Found

Related InterviewSolutions