Question 35

Concurrency control in RDBMS is important for which of the following reasons ?

  1. ATo ensure data integrity when reads occur to the database in a multi-user environment.
  2. BTo ensure data integrity when updates occur to the database in a single-user environment.
  3. CTo ensure data integrity when updates occur to the database in a multi-user environment.
  4. DTo ensure data integrity when reads occur to the database in a single-user environment.
Show answerHide answer

Correct answer: (C) To ensure data integrity when updates occur to the database in a multi-user environment.

Explanation

Concurrency control keeps data consistent when several users update the database at the same time, preventing lost updates and inconsistent reads.

From DSSSB TGT Computer Science Practice Set 2

This is question 35 of DSSSB TGT Computer Science Practice Set 2. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.