CAF-3 · Chapter 5 · Question 2 of 15
A customer transfers Rs. 10,000 to another account. The system deducts the money from the sender but crashes before adding it to the receiver. When the system restarts, it completely rolls back the deduction as if it never happened. Which ACID property ensures this "all or nothing" execution?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: A) Atomicity
Explanation
Atomicity ensures that a transaction is treated as a single, indivisible unit. It guarantees an "all or nothing" execution, meaning if any part of the transaction fails, the entire transaction is rolled back
More Types of DBMS MCQs
- Q4Once an online order is confirmed by the DBMS, the changes are permanently saved in the database. Even if a sudden power failure occurs…
- Q5In a company's database, the HR department has a view showing employee salaries, while the Sales department has a view showing customer…
- Q6Which level of the DBMS architecture acts as the global logical view of the entire database, defining entities, attributes, and…
- Q7The IT department decides to re-index the database and move the data files to a new, faster SSD storage drive. This change does not affect…
- Q8The ability to modify the physical storage mechanisms (like changing hard drives or compressing data) without impacting the logical…