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

    Question 1: Transactions in RDBMS - Definition

    What is a transaction in the context of RDBMS?

    Question 2: ACID - Atomicity Concept

    What does Atomicity ensure in a database transaction?

    Question 3: ACID - Consistency Concept

    Which statement best describes Consistency in ACID?

    Question 4: ACID - Isolation Concept

    What does Isolation mean in database transactions?

    Question 5: ACID - Durability Concept

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

    Question 6: Transaction States

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

    Question 7: Commit and Rollback

    What is the purpose of COMMIT and ROLLBACK in transactions?

    Question 8: Isolation Levels

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

    Question 9: ACID Benefits

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

    Question 10: Transaction Example

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