Which of the following is NOT a characteristic of a transaction in a DBMS?
Practice Questions
1 question
Q1
Which of the following is NOT a characteristic of a transaction in a DBMS?
Atomicity
Consistency
Isolation
Redundancy
Redundancy is not a characteristic of a transaction; the main properties are Atomicity, Consistency, Isolation, and Durability (ACID).
Questions & Step-by-step Solutions
1 item
Q
Q: Which of the following is NOT a characteristic of a transaction in a DBMS?
Solution: Redundancy is not a characteristic of a transaction; the main properties are Atomicity, Consistency, Isolation, and Durability (ACID).
Steps: 4
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 the main properties of transactions, known as ACID: Atomicity (all or nothing), Consistency (valid state), Isolation (independent execution), and Durability (permanent changes).
Step 3: Identify characteristics that are NOT part of a transaction. Redundancy means having unnecessary copies of data, which is not a property of transactions.
Step 4: Conclude that redundancy is NOT a characteristic of a transaction in a DBMS.
