Which of the following is NOT a characteristic of a transaction in a DBMS?

₹0.0

Question: Which of the following is NOT a characteristic of a transaction in a DBMS?

Options:

Correct Answer: Redundancy

Solution:

Redundancy is not a characteristic of a transaction; the main properties are Atomicity, Consistency, Isolation, and Durability (ACID).

Which of the following is NOT a characteristic of a transaction in a DBMS?

Which of the following is NOT 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 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.

No concepts available.