A money transfer has reduced the source account balance, but the step that increases the destination account balance fails. What should the application do?
Database Transactions and ACID Properties Online Quiz Questions
Use this free practice quiz with 20 questions to review Database Transactions and ACID Properties, test your knowledge, and prepare for your next test or exam.
Select all statements that accurately describe the ACID properties of transactions.
- A
Atomicity: all operations in a transaction take effect, or none do.
- B
Atomicity: a successful commit guarantees recovery from every possible failure.
- C
Consistency: committed changes preserve the database’s defined constraints and rules.
- D
Isolation: concurrent transactions do not produce results that violate the chosen isolation guarantees.
- E
Durability: a transaction always preserves all constraints, even before it commits.
- F
Durability: after a successful commit, changes survive failures covered by the database’s durability mechanisms.
A successful commit makes changes durable against failures covered by the database’s durability mechanisms.
- A
True
- B
False
Which ACID property concerns concurrent transactions not producing results that violate the chosen isolation guarantees?
A transaction completes with or is undone with ROLLBACK.
Explain how a transaction should handle a money transfer if one of its steps fails. Include why both balance changes belong together and what should be checked about the source account.
A committed database change preserves the database’s defined constraints and rules. Which ACID property does this describe?
- A
Atomicity
- B
Isolation
- C
Consistency
- D
Durability
A developer is implementing a money transfer. Select all practices supported for handling the transfer reliably.
- A
Place the balance reduction and increase in the same transaction.
- B
Commit the reduction even if the increase fails.
- C
Roll back if a step fails rather than committing a partial transfer.
- D
Treat a successful transaction as proof that the source account existed and had sufficient funds, without checking.
- E
Check that the source account exists and has sufficient funds.
Exact transaction syntax and behavior are identical across all database systems.
- A
True
- B
False
What SQL command undoes a transaction instead of completing it with COMMIT?
A database transaction completes successfully with ; if it must be undone, use .
A money transfer must either reduce one account's balance and increase the other's, or do neither. Which ACID property describes this all-or-nothing requirement?
- A
Consistency
- B
Atomicity
- C
Isolation
- D
Durability
Which ACID property means that either all operations in a transaction take effect or none do?
A transaction has committed successfully. Which statement describes durability?
- A
The transaction's operations are all-or-nothing.
- B
Committed changes preserve database constraints.
- C
Committed changes survive failures covered by the database's durability mechanisms.
- D
Concurrent transactions meet the chosen isolation guarantees.
Isolation aims to prevent concurrent transactions from producing results that violate the chosen isolation guarantees.
- A
True
- B
False
Which ACID property concerns concurrent transactions not producing results that violate the chosen isolation guarantees?
During a transfer, one step fails before both account balances have been updated. What should the application do to avoid committing a partial transfer?
- A
Roll back the transaction rather than commit a partial transfer.
- B
Commit the transaction so the completed step is saved.
- C
Commit the debit and retry the credit later.
- D
Treat the failure as unrelated to the transaction.
Before carrying out a money transfer, which checks should the transaction make about the source account?
- A
Check only that the destination account exists.
- B
Check only that the source account exists.
- C
Check only that the source account has sufficient funds.
- D
Check that the source account exists and has sufficient funds.
A money transfer reduces one account balance, but the step that increases the other balance fails. Which ACID property explains why the transaction should not leave only the reduction committed?
- A
Consistency
- B
Atomicity
- C
Isolation
- D
Durability
A transaction commits a change while preserving the database’s defined constraints and rules. Which ACID property does this describe?
- A
A committed change survives failures covered by the database’s durability mechanisms.
- B
Concurrent transactions meet the chosen isolation guarantees.
- C
Committed changes preserve the database’s defined constraints and rules.
- D
All operations in a transaction take effect, or none do.
Related study packs and tools
02 — Information and Representation
A progressive guide to how computers encode numbers, text, images, and sound as binary data, including the trade-offs and limits of digital representation.
2 Digital Logic
A 14-question medium-difficulty quiz on Boolean algebra, logic gates, truth tables, and combinational circuits.
03 — Python Programming Fundamentals
A focused set of flashcards covering Python variables, data types, expressions, control flow, functions, input, output, and common programming practices.
6 Computer Memory
Learn how computer memory stores and addresses information, how RAM and ROM differ, and how caches and the memory hierarchy balance speed, capacity, and cost.
07 Trees and Binary Search Trees
A progressive guide to tree structure, binary-tree traversals, binary search tree operations, deletion, balancing, and the way tree height determines time and space costs.
10 — Data, Systems, and Applications
A progression through how data is organized, searched, exposed through software interfaces, and managed through abstraction layers in modern computer systems.
Interrupts
Reviews how interrupts support event handling and multitasking, and how Linux system calls use the RISC-V `ecall` instruction and register conventions.
OS Processes
This quiz covers process management, context switching and scheduling, multitasking, traps and interrupts, and RISC-V privilege transitions.
Systemcalls
A quiz on operating-system system calls, including privileged-operation requests, process creation and execution with fork, exec, and waitpid, and signal handling.