An audit of a banking transactions system has found that on an earlier occasion, two joint holders of account A attempted simultaneous transfers of Rs. 10000 each from account A to account B. Both transactions read the same value, Rs. 11000, as the initial balance in A and were allowed to go through. B was credited Rs. 10000 twice. A was debited only once and ended up with a balance of Rs. 1000.
Which of the following properties is/are certain to have been violated by the system?
Solution :
The correct options are Consistency and Isolation.
To understand why these properties are violated, let us analyze the scenario step-by-step using the ACID (Atomicity, Consistency, Isolation, Durability) properties of database transactions.
1. Violation of Isolation:
Isolation ensures that the concurrent execution of transactions results in a system state that is equivalent to the transactions being executed serially (one after another).
In this scenario:
- Both Transaction 1 () and Transaction 2 () read the initial balance of Account A as Rs. 11000 at the same time.
- calculates the new balance for A as: 11000 - 10000 = 1000, and writes this value back.
- Concurrent with this, also calculates the new balance for A as: 11000 - 10000 = 1000, and writes this value back.
This is a classic lost update anomaly. Because the transactions did not run in isolation, the update made by one transaction was overwritten by the other. If they had been properly isolated (e.g., using serializable transaction scheduling or locking), the second transaction would have read the balance of A only after the first transaction had committed (seeing Rs. 1000 instead of Rs. 11000), which would have prevented the second transfer of Rs. 10000 due to insufficient funds.
2. Violation of Consistency:
Consistency ensures that a transaction database must transition from one consistent/valid state to another, maintaining all predefined integrity rules (such as database constraints or financial balancing rules).
In a banking transfer application, a fundamental consistency rule is the conservation of money: the total debit from the source account must equal the total credit to the destination account.
In this scenario:
- Account A was debited only once by Rs. 10000 (ending up with Rs. 1000 instead of Rs. 11000).
- Account B was credited twice by Rs. 10000 (a total credit of Rs. 20000).
Because the total debited amount (Rs. 10000) does not match the total credited amount (Rs. 20000), the system's financial integrity constraints are broken, violating the Consistency property.
Why Atomicity and Durability are not certainly violated:
- Atomicity: Atomicity requires that a transaction must either fully complete or not happen at all. In this case, both transactions successfully performed their read, debit, and credit steps. The issue is not that they were partially executed, but that they interfered with each other.
- Durability: Durability ensures that once a transaction is committed, its changes survive system failures. Since the incorrect final balances were successfully saved and found during the audit, the database successfully persisted the updates.
Completely free for students. Educators & coaching institutes get 2 months free Pro trial to create tests.
Access unlimited practice questions, detailed step-by-step solutions, and exam study materials — completely free for students.
Create and conduct professional online assessments with AI question generation, tab proctoring, and comprehensive batch management.
A comprehensive CUET UG Mathematics Question Paper with Solutions – 2 June 2023 (Shift 3) designed to help students practice and understand the actual CUET exam pattern. This paper covers important topics from Algebra, Calculus, Coordinate Geometry, Probability, Statistics, Matrices, Determinants, and Vectors, featuring a balanced mix of conceptual, numerical, and application-based questions. Detailed solutions are provided to strengthen problem-solving skills, improve conceptual clarity, and enhance calculation accuracy. Based on the CUET syllabus and previous year exam trends, this paper is ideal for practice, revision, self-assessment, time management, previous year analysis, and final preparation for upcoming CUET UG Mathematics examinations.
A comprehensive CUET Accountancy Question Paper – 20 June 2023 (Shift 2) designed to help students practice and analyze previous year exam patterns for effective CUET preparation. This paper covers important topics including Accounting for Partnership Firms, Company Accounts, Financial Statements Analysis, Cash Flow Statements, Accounting Ratios, and Fundamental Accounting Principles. It features a balanced mix of conceptual, numerical, and application-based questions to strengthen accounting concepts, improve calculation accuracy, and enhance problem-solving skills. Based on the CUET exam structure and syllabus, this paper is ideal for practice, revision, self-assessment, time management, previous year analysis, and final preparation for upcoming CUET Accountancy examinations.
Copyright © 2026 Combe Labs Private Limited. All Rights Reserved.