Question 176Asked in CIL MT Systems, 24 Aug 2026 (3:00 PM, CBT-26)

Which of the following scenarios best describes a violation of the consistency property?

  1. ATwo transactions read and write the same record simultaneously.
  2. BData from a committed transaction is deleted after a restart.
  3. CA transaction partially runs due to a crash.
  4. DA transaction completes but leaves the database in a state where total credits ≠ total debits.
Show answerHide answer

Correct answer: (D) A transaction completes but leaves the database in a state where total credits ≠ total debits.

From CIL MT Systems PYQ, 24 Aug 2026 (3:00 PM, CBT-26)

This is question 176 of CIL MT Systems PYQ, 24 Aug 2026 (3:00 PM, CBT-26). 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.