Concurrency control in RDBMS is important for which of the following reasons?
Concurrency control in RDBMS is important for which of the following reasons?
Answer: C. To ensure data integrity when updates occur to the database in a multi-user environment. — Concurrency control is required when multiple users update data simultaneously . It prevents problems like lost update, dirty read, and inconsistency . Hence,…
- A.
To ensure data integrity when reads occur to the database in a multi-user environment.
- B.
To ensure data integrity when updates occur to the database in a single-user environment.
- C.
To ensure data integrity when updates occur to the database in a multi-user environment.
- D.
To ensure data integrity when reads occur to the database in a single-user environment.
Attempted by 238 students.
Show answer & explanation
Correct answer: C
Concurrency control is required when multiple users update data simultaneously .
It prevents problems like lost update, dirty read, and inconsistency .
Hence, it is needed for updates in a multi-user environment .