Which DBMS feature ensures that a transaction is executed completely or has no effect at all?

Options

  • A. Isolation
  • B. Durability
  • C. Atomicity
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. Atomicity

Detailed Explanation

  • Atomicity: Ensures that all operations in a transaction succeed or none of them take effect.
  • It prevents partial transaction completion.
  • Atomicity is one of the four ACID properties.