Which of the following is NOT a property of transactions in a DBMS?
Practice Questions
Q1
Which of the following is NOT a property of transactions in a DBMS?
Atomicity
Consistency
Isolation
Redundancy
Questions & Step-by-Step Solutions
Which of the following is NOT a property of transactions in a DBMS?
Step 1: Understand what a DBMS is. A DBMS (Database Management System) is software that helps manage databases.
Step 2: Learn about transactions in a DBMS. A transaction is a sequence of operations performed as a single logical unit of work.
Step 3: Familiarize yourself with the ACID properties of transactions. ACID stands for Atomicity, Consistency, Isolation, and Durability.
Step 4: Identify what each ACID property means: Atomicity means all operations in a transaction are completed or none are; Consistency ensures the database remains in a valid state; Isolation ensures transactions do not interfere with each other; Durability guarantees that once a transaction is committed, it remains so even in case of a failure.
Step 5: Recognize that redundancy is not one of the ACID properties. Redundancy refers to unnecessary duplication of data, which is not a desired property of transactions.
