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…

Submitted by haruto_sh· Mar 30, 2026Identify considerations for relational data on Azure

Question

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

Options

Aisolation
Bdurability
Catomicity
Dconsistency

How the community answered

(22 responses)

A
5% (1)
B
5% (1)
C
91% (20)

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 client.

Topics

#ACID properties#atomicity#database transactions#relational data

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice