Question

Difference between deferred database modification and immediate database modification with example.

Answer 1

Deferred database modification − All logs are written on to the stable storage and the database is updated when a transaction commits. Immediate database modification − Each log follows an actual database modification. That is, the database is modified immediately after every operation.