quiz

Transactions in DBMS

1. Which of the following properties ensures that either all operations in a transaction are executed or none at all?

  • A) Atomicity
  • B) Consistency
  • C) Isolation
  • D) Durability
A) Atomicity Explanation

2. In a database system, what state does a transaction reach after executing its final operation successfully?

  • A) Active
  • B) Partially Committed
  • C) Failed
  • D) Committed
B) Partially Committed Explanation

3. Which type of equivalence schedule is concerned with transactions performing similar actions in a similar manner?

  • A) View Equivalence
  • B) Result Equivalence
  • C) Conflict Equivalence
  • D) Serial Equivalence
A) View Equivalence Explanation

4. Which of the following is NOT one of the ACID properties of transactions in a database management system?

  • A) Atomicity
  • B) Consistency
  • C) Integrity
  • D) Durability
C) Integrity Explanation

5. In what state does a transaction reside when the recovery manager rolls back its operations to the database’s original state?

  • A) Active
  • B) Partially Committed
  • C) Failed
  • D) Aborted
D) Aborted Explanation

Quick Links