CSE 480 Question and answers 100%
correct 2025/2026
Atomicity - correct answer ✔Transactions are often composed of multiple statements.
Guarantees that transactions are treated as a single unit, which either succeeds completely, or fails
completely.
If any statement constituting a transactions fails to complete, the entire transaction fails and the
database is left unchanged.
Systems based on this property will guarantee this property in each and every situation including power
failures, errors, and crashes.
Consistency (ACID) - correct answer ✔Ensures that a transaction can only bring the database from one
valid state to another, maintaining database invariant.
This prevents database corruption by an illegal transaction, but does not guarantee that a transaction is
correct.
Invariant - correct answer ✔Any data written to the database must be valid according to all defined
rules, including constraints, cascades, triggers, or any combination of these rules.
Isolation - correct answer ✔Ensures that concurrent execution of transactions leave the database in
the same state that would have been obtained if the transaction were executed sequentially.
Concurrent Execution - correct answer ✔Reading and writing to multiple tables at the same time.
correct 2025/2026
Atomicity - correct answer ✔Transactions are often composed of multiple statements.
Guarantees that transactions are treated as a single unit, which either succeeds completely, or fails
completely.
If any statement constituting a transactions fails to complete, the entire transaction fails and the
database is left unchanged.
Systems based on this property will guarantee this property in each and every situation including power
failures, errors, and crashes.
Consistency (ACID) - correct answer ✔Ensures that a transaction can only bring the database from one
valid state to another, maintaining database invariant.
This prevents database corruption by an illegal transaction, but does not guarantee that a transaction is
correct.
Invariant - correct answer ✔Any data written to the database must be valid according to all defined
rules, including constraints, cascades, triggers, or any combination of these rules.
Isolation - correct answer ✔Ensures that concurrent execution of transactions leave the database in
the same state that would have been obtained if the transaction were executed sequentially.
Concurrent Execution - correct answer ✔Reading and writing to multiple tables at the same time.
