Question

What is the durability property of transactions?

(a) statements form a logic unit

(b) database remains consistent

(c) one transaction does not affect the other

(d) transaction effects are recorded permanently

The question was asked by my school teacher while I was bunking the class.

This interesting question is from Performing Transactions topic in chapter Using SQL to Manage Data of MySQL

Answer 1

Right answer is (d) transaction effects are recorded permanently

To explain I would say: The ‘durability’ property of a transaction is one of the four elementary characteristics that are expected for a database transaction to maintain throughout. The others are Isolation, Atomicity and Consistency.