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...
A(n) ____ query performs calculations on the values in a field and displays the results in a datasheet.
A. crosstab B. action C. select D. calculation
Which of the following linear data structures allow users to make removals from the front?
a) queues. b) stacks. c) linked lists. d) Both a and c.
____________ encompasses a broad set of activities that include planning, coding, testing, and documenting while a related activity, __________, is a development process that uses mathematical, engineering, and management techniques to reduce the cost and complexity of a computer program while increasing its reliability and modifiability.?
A. ?Software engineering, computer programming B. ?Computer programming, software engineering C. ?Application programming, systems programming D. ?Systems programming, application programming
The HTML code for an active server page includes the HTML to format and display the page, and might include JavaScript code to perform certain processing, such as ensuring that a text box contains data.
Answer the following statement true (T) or false (F)