The initials of four properties a transaction should satisfy: atomicity (everything is executed or nothing is), consistency (integrity constraints keep being satisfied), isolation (concurrent transactions do not interfere with each other) and durability (committed results are not lost even if a failure occurs).
Japanese name: ACID特性
ACID properties appears in 2 practice questions across 1 topic, including Database Basics.
Field: Database Basics
Answer: C. Atomicity
The ACID properties are named after the initials of four properties a transaction should satisfy. Atomicity means the operations in a transaction are either all executed or none are; if a failure occurs, the updates made so far are cancelled. Consistency means the data keeps satisfying integrity constraints (balances never negative, foreign keys always referring to existing rows, and so on) before and after the transaction. Isolation means that transactions running concurrently do not interfere with each other and produce the same result as if they had been executed one at a time. Durability means that the results of a committed transaction are not lost even if a failure occurs afterwards. The all-or-nothing property in the question is atomicity.
The ACID properties are named after the initials of four properties a transaction should satisfy.
Among the ACID properties a transaction should have, which …This mechanism underpins the atomicity and durability of the ACID properties.
When updating data, many DBMSs record the changes in a log …As an Amazon Associate I earn from qualifying purchases.
Transaction Database index Database view E-R diagram Foreign key Isolation level Normalization NoSQL Primary key Relational database