Question 41
In ACID properties of a database transaction, 'A' stands for -
ACID stands for Atomicity (all or nothing execution), Consistency, Isolation, and Durability.
In ACID properties of a database transaction, 'A' stands for -
ACID stands for Atomicity (all or nothing execution), Consistency, Isolation, and Durability.
Which ACID property ensures that either all operations of a transaction execute completely or none of them do?
Atomicity guarantees the 'All-or-Nothing' rule-if a transaction fails mid-way, all changes are rolled back completely.
Which ACID property guarantees that committed transaction results persist even in the event of a system crash?
Durability ensures that once a transaction commits, its changes are permanently written to non-volatile storage and survive power/system crashes.
Which ACID property ensures that concurrent execution of transactions leaves the database in the same state as serial execution?
Isolation prevents concurrent transactions from interfering with one another, making concurrent executions appear as if run serially.
In Two-Phase Locking (2PL) protocol, what are the two phases?
2PL consists of a Growing Phase (where new locks are acquired and no locks released) followed by a Shrinking Phase (where locks are released and no new locks acquired).