Explain each of the following.
(a) Why a log has to have the write-ahead property
(b) Why a checkpoint record is appended to the log periodically
(a) Why a log has to have the write-ahead property
Solution:
If the information was written to the database rst and then to the log, and the system
crashed between the two writes, there would be no way to rollback the changes
(b) Why a checkpoint record is appended to the log periodically
Solution:
Otherwise, in the event of a crash, the entire log would have to be scanned to perform
the recover
You might also like to view...
Windows Firewall is protection built into Windows 10 that can prevent hackers or malicious software from gaining access to your computer through a network or the Internet
Indicate whether the statement is true or false
You should use bullets for an ordered hierarchical list
Indicate whether the statement is true or false