Question

The value of the data item prior to the write is called as _________

(a) Transaction identifier

(b) Data-item identifier

(c) Old value

(d) New value

This question was posed to me during an internship interview.

My question is from Recovery and Atomicity in section Recovery System of RDBMS

Answer 1

Right answer is (c) Old value

To explain I would say: The value of the data item prior to the write is called as old value. This is stored in the update log record.