nerdexam
Microsoft

AI-102 · Question #142

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

The correct answer is C. atomicity. An atomic transaction is an indivisible and irreducible series of database operations such that either all occurs, or nothing occurs. A guarantee of atomicity prevents updates to the database occurring only partially, which can cause greater problems than rejecting the whole seri

Submitted by yaw92· Mar 30, 2026Analyze solution requirements

Question

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

Options

  • Aconsistency
  • Bisolation
  • Catomicity
  • Ddurability

How the community answered

(29 responses)
  • A
    3% (1)
  • C
    93% (27)
  • D
    3% (1)

Explanation

An atomic transaction is an indivisible and irreducible series of database operations such that either all occurs, or nothing occurs. A guarantee of atomicity prevents updates to the database occurring only partially, which can cause greater problems than rejecting the whole series outright. As a consequence, the transaction cannot be observed to be in progress by another database

Topics

#ACID properties#atomicity#database transactions#data integrity

Community Discussion

No community discussion yet for this question.

Full AI-102 Practice