Which of the following is a characteristic of a transaction in a database?
Correct Answer: ACID properties
- Step 1: Understand that a transaction is a sequence of operations performed as a single logical unit of work in a database.
- Step 2: Learn about the ACID properties that define transactions:
- Step 3: Atomicity means that all operations in a transaction must complete successfully, or none at all.
- Step 4: Consistency ensures that a transaction brings the database from one valid state to another valid state.
- Step 5: Isolation means that transactions do not interfere with each other, even if they are executed at the same time.
- Step 6: Durability guarantees that once a transaction is committed, it will remain so, even in the event of a system failure.
No concepts available.