Which set consists entirely of responsibilities associated with transaction…
2012
Which set consists entirely of responsibilities associated with transaction management in a DBMS?
Answer: D. Transaction logging, update-image maintenance, and concurrency control — ConceptTransaction management preserves the ACID properties of transactions. It coordinates concurrent execution and supplies recovery information so that…
- A.
Query parsing, view rendering, and report formatting
- B.
Schema definition, index creation, and authorization management
- C.
File compression, backup scheduling, and network routing
- D.
Transaction logging, update-image maintenance, and concurrency control
Attempted by 185 students.
Show answer & explanation
Correct answer: D
Concept
Transaction management preserves the ACID properties of transactions. It coordinates concurrent execution and supplies recovery information so that committed work is retained and incomplete work can be undone after a failure.
Application
Transaction logging records actions and status changes. Before-images and after-images preserve values needed for undo and redo. Concurrency-control protocols such as locking or timestamp ordering isolate simultaneous transactions.
Contrast
Query parsing, view rendering, and report formatting concern statement processing and result presentation.
Schema definition, index creation, and authorization management concern structure, access paths, and security.
File compression, backup scheduling, and network routing concern storage or operational infrastructure.
Transaction logging, update-image maintenance, and concurrency control jointly support recovery and isolated execution.
Result
Therefore, the complete transaction-management set is transaction logging, update-image maintenance, and concurrency control.