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
Question
Options
- Aconsistency
- Bisolation
- Catomicity
- Ddurability
How the community answered
(29 responses)- A3% (1)
- C93% (27)
- D3% (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
Community Discussion
No community discussion yet for this question.