Database Interview in Technical Lead Round: Why is it important to write to the log before changing the database values?
The most important objective to write the log before the database is changed is if there is any need to rollback or rollforward any transaction then if the log are not present then the rollback rollforward cannot be done accurately.