Practice mode DBMS and SQL

What does the write-ahead logging (WAL) rule require?

Correct answer B. Log records describing a change must reach stable storage before the changed data page does

Explanation

Under WAL, a modified data page may be written to disk only after the log records describing that modification have been flushed. Then, after a crash, the log always holds enough information to undo or redo any change found on disk. The first option reverses the rule. Writing all data pages at commit is the FORCE policy, which WAL lets the DBMS avoid.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.