...
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

Database-Management-System

Question 900
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 900 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 900 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.

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!