...
Software-Engineering
November 8, 2023
Question 12653 – Probability-and-statistics
November 8, 2023
Software-Engineering
November 8, 2023
Question 12653 – Probability-and-statistics
November 8, 2023

NTA UGC NET JUNE-2023 Paper-2

Question 16
Which one of the following is Not a part of ACID properties of a database transaction?
A
Atomicity
B
Consistency
C
Isolation
D
Deadlock-freedom
Question 16 Explanation: 
“Deadlock-freedom” is not typically considered one of the ACID properties of a database transaction. The ACID properties include:

Atomicity: Transactions are treated as all-or-nothing units. Either all the changes are applied, or none of them are.

Consistency: A transaction should bring the database from one consistent state to another consistent state. It ensures that the integrity constraints and rules are not violated during the transaction.

Isolation: Transactions should be isolated from each other, meaning the operations within a transaction should not interfere with other concurrent transactions.

Durability: Once a transaction is committed, its changes are permanent and will survive system failures.

“Deadlock-freedom” is related to concurrency control mechanisms and techniques but is not typically considered one of the core ACID properties. It’s concerned with avoiding situations where multiple transactions are waiting for each other, leading to a standstill in processing.

Correct Answer: D
Question 16 Explanation: 
“Deadlock-freedom” is not typically considered one of the ACID properties of a database transaction. The ACID properties include:

Atomicity: Transactions are treated as all-or-nothing units. Either all the changes are applied, or none of them are.

Consistency: A transaction should bring the database from one consistent state to another consistent state. It ensures that the integrity constraints and rules are not violated during the transaction.

Isolation: Transactions should be isolated from each other, meaning the operations within a transaction should not interfere with other concurrent transactions.

Durability: Once a transaction is committed, its changes are permanent and will survive system failures.

“Deadlock-freedom” is related to concurrency control mechanisms and techniques but is not typically considered one of the core ACID properties. It’s concerned with avoiding situations where multiple transactions are waiting for each other, leading to a standstill in processing.

Leave a Reply

Your email address will not be published. Required fields are marked *