Question 17091 – NTA UGC NET JUNE-2023 Paper-2

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.