All Questions

Transactions and ACID Properties – Atomicity, Consistency, Isolation, Durability.

MCQ Question 1 of 10

Question 1: Transactions in RDBMS - Definition

What is a transaction in the context of RDBMS?

A single SQL queryA sequence of one or more operations performed as a single unitA backup operationAn index creation

Question 2: ACID - Atomicity Concept

What does Atomicity ensure in a database transaction?

Transaction changes are permanentAll operations in a transaction are executed fully or not at allDatabase remains in a consistent stateMultiple transactions run concurrently

Question 3: ACID - Consistency Concept

Which statement best describes Consistency in ACID?

Database moves from one valid state to another valid stateTransaction changes are permanentAll operations succeed or failMultiple transactions are isolated

Question 4: ACID - Isolation Concept

What does Isolation mean in database transactions?

Transactions are executed sequentiallyChanges in a transaction are invisible to others until committedOnly one transaction can run at a timeDatabase backup occurs automatically

Question 5: ACID - Durability Concept

Which property ensures that once a transaction is committed, its changes remain permanent, even in case of system failure?

AtomicityConsistencyIsolationDurability

Question 6: Transaction States

Which of the following is a valid state of a transaction in RDBMS?

Active, Partially Committed, Failed, Committed, TerminatedInsert, Update, Delete, SelectTemporary, PermanentValid, Invalid

Question 7: Commit and Rollback

What is the purpose of COMMIT and ROLLBACK in transactions?

COMMIT saves changes; ROLLBACK undoes changesBoth save changes permanentlyCOMMIT undoes changes; ROLLBACK saves changesThey create indexes automatically

Question 8: Isolation Levels

Which isolation level allows maximum concurrency but may cause dirty reads?

READ UNCOMMITTEDREAD COMMITTEDREPEATABLE READSERIALIZABLE

Question 9: ACID Benefits

What is the main benefit of enforcing ACID properties in RDBMS transactions?

Faster query execution onlyEnsures reliability, consistency, and integrity of dataReduces storage requirementsAllows unlimited concurrent updates

Question 10: Transaction Example

In a banking application, transferring money between accounts is a transaction. Why must it follow ACID principles?

To guarantee money is deducted but not addedTo ensure either both debit and credit succeed or both failTo allow partial transferTo create duplicate account records