Few database engines function by making changes physically in the database as soon as the change is made (regardless of the execution of a COMMIT or ROLLBACK command).

Question

Quizplus · Accepted Answer

Most database engines use a mechanism called write-ahead logging to record changes in a log file before applying them to the database. This allows for efficient data recovery in case of a failure or a rollback request before committing the changes.

Few Database Engines Function by Making Changes Physically in the Database