A logical unit of database processing that includes one or more database access operations (read, write) is termed a:
A transaction is an executing program or atomic logical unit of work that performs read and write operations on the database.
Which of the following is part of the standard ACID properties of database transactions?
ACID stands for Atomicity, Consistency, Isolation, and Durability. Both (A) and (B) list valid ACID properties, so more than one of the above is correct.
The property ensuring that either all operations of a transaction are executed successfully or none are reflected in the database is:
Atomicity refers to the all-or-nothing property of a transaction managed primarily by the recovery management component.
Which component of a DBMS is primarily responsible for ensuring the Atomicity and Durability of transactions?
The Recovery Manager ensures Atomicity (rolling back uncommitted changes) and Durability (committing updates to permanent storage via log files).
Which DBMS component is primarily responsible for ensuring the Isolation property of concurrently executing transactions?
The Concurrency Control Manager ensures Isolation using protocols like 2PL, timestamp ordering, or multiversion concurrency control.