Which of the following is a characteristic of a transaction in a DBMS?
Practice Questions
Q1
Which of the following is a characteristic of a transaction in a DBMS?
Atomicity
Redundancy
Isolation
Both Atomicity and Isolation
Questions & Step-by-Step Solutions
Which of the following is a characteristic of a transaction in a DBMS?
Step 1: Understand what a transaction is in a Database Management System (DBMS). A transaction is a sequence of operations performed as a single logical unit of work.
Step 2: Learn about Atomicity. This means that a transaction must be all completed or none at all. If one part of the transaction fails, the entire transaction fails.
Step 3: Learn about Isolation. This means that transactions are executed independently of one another. Even if multiple transactions are happening at the same time, they do not interfere with each other.
Step 4: Recognize that these characteristics (Atomicity and Isolation) help maintain the integrity of the database.
