Properties of ACID in Database Transactions

What does ACID stand for in the context of database transactions?

• Atomicity, Consistency, Isolation, Durability

• Accuracy, Consistency, Integrity, Durability

• Atomicity, Correctness, Isolation, Durability

• Atomicity, Consistency, Integration, Durability

Which property of ACID ensures that a transaction is all-or-nothing, meaning either all its operations succeed or none are applied?

• Atomicity

• Consistency

• Isolation

• Durability

If the transaction fails, any changes made during the transaction are discarded. This process is called _______.

• Abort/Rollback

• Commit

• Checkpoint

• Locking

Consider the following transaction T consisting of T1 and T2: Transfer of $100 from account X to account Y. Which ACID property does this example illustrate?

• Atomicity

• Consistency

• Isolation

• Durability

What does Atomicity in database transactions ensure?

• Only part of a transaction is completed

• If any part of the transaction fails, the entire process is rolled back to its original state

• Transactions can be partially saved

• Transactions are always consistent

Consistency in transactions means that the database must remain in a valid state before and after a transaction.

• True

• False

Suppose the sum of all balances in a bank system should always be constant. Before a transfer, the total balance is $700. After the transaction, the total balance should remain ____.

• $700

• $600

• $800

• $0

If a transaction deducts money from one account but doesn't add it to another (in a transfer), it violates which property?

• Atomicity

• Consistency

• Durability

• Isolation

What does Isolation ensure in database transactions?

• A) Transactions run independently without affecting each other

• B) Transactions are visible to all users immediately

• C) Transactions always fail

• D) Transactions are never committed

Which of the following is described as reading uncommitted data?

• Non-repeatable reads

• Dirty reads

• Phantom reads

• Committed reads