Question Details

Two joint holders attempted simultaneous transfers of Rs. 10000 each. Both read Rs. 11000 balance. A was debited only once (final balance 1000). Which properties were violated?

Options

A

Atomicity

B

Consistency

C

Isolation

D

Durability

Show Answer
Correct Answer
B Consistency

Solution :

The correct option is Consistency.

To understand why the consistency property is violated, let us analyze the scenario step-by-step:

1. Understanding the Consistency Property (C in ACID):
Consistency ensures that a database transition takes the database from one valid state to another, preserving all system invariants, integrity constraints, and business rules (for example, the total money transferred must equal the total money deducted from accounts).

2. Analyzing the Scenario:
Let the initial balance in the account be:
Initial Balance=11000
Two joint holders simultaneously attempt to transfer Rs. 10,000 each. Both read the same initial balance of Rs. 11,000. Let the two transfers be represented by transaction T1 and transaction T2.

3. The Mathematical Discrepancy:
If both transfers are processed, a total of Rs. 20,000 is sent out of the system. The mathematically expected final balance of the account should be:
Expected Balance=11000-10000-10000=-9000
However, the system debits the account only once, resulting in a final balance of:
Final Balance=11000-10000=1000

4. Conclusion:
Because the account was only debited once (Rs. 10,000) while two separate transfers of Rs. 10,000 were executed, Rs. 10,000 has been created out of thin air. This violation of the fundamental rule of balance conservation breaks the integrity of the data, which directly violates the Consistency property.

Transparent Access on Mindyard

Built for Learners & Educators Alike

Completely free for students. Educators & coaching institutes get 2 months free Pro trial to create tests.

FREE FOR STUDENTS

Practice & Learn Free for Students

Access unlimited practice questions, detailed step-by-step solutions, and exam study materials — completely free for students.

  • Unlimited mock tests & question bank practice
  • Full access to curated study library & formula notes
  • 100% free for students • No credit card required
2 MONTHS FREE TRIAL

Educators & Coaching Institutes

Create and conduct professional online assessments with AI question generation, tab proctoring, and comprehensive batch management.

  • AI question uploader & rapid test generator
  • Anti-cheating tab proctoring & performance reports
  • Full Pro access free for 60 days • No upfront commitment
Discover more resources

You may also like

Mock Tests

View All
  • GATE
  • beginner
  • 3 hours
  • civil engineering

Prepare for GATE 2026 Civil Engineering with the latest question papers, previous year papers, detailed solutions, syllabus, exam pattern, preparation tips, mock tests, and subject-wise study material. Download GATE 2026 CE question papers with solutions in PDF format and boost your preparation for top engineering institutes and PSU recruitment.

  • GATE
  • beginner
  • 3 hours
  • electronics and communication engineering

Prepare effectively for GATE 2026 Electronics & Communication Engineering (EC) with this comprehensive Question Paper with Solutions. This resource includes detailed explanations, concept-wise solutions, previous year paper analysis, and exam-oriented practice to help aspirants strengthen core subjects like Electronic Devices, Analog Circuits, Digital Circuits, Signals & Systems, Network Theory, Control Systems, Electromagnetics, Communications, and more. Perfect for revision, self-assessment, and boosting your GATE 2026 EC preparation strategy.

Ask AI Tutor
5 left
Q1 View Question & Options
AI Tutor is solving this question...
Reading question context & options...
Ask your own doubt or choose a quick prompt: