Suppose that a dirty page in the cache has been written by two active transactions and that one of the transactions commits. Describe howthe caching procedure works in this case.
What will be an ideal response?
The write-ahead feature implies that the page cannot be written until the update records of both transactions have been stored in the log. Assuming update records contain after-images, the page does not have to be written out except as dictated by the rule relating to the use of checkpoint records.
You might also like to view...
A website that may help locate public records in the United Kingdom is ________.
a. www.pacer.psc.uscourts.gov/ b. www.bop.gov/ c. www.searchsystems.net/ d. www.pro.gov.uk/
Which of the following is the escape character?
a. * b. \ c. \n d. "
Initializing an array with a number of elements ____ the array's size is not allowed in any programming language.
A. fewer than B. more than C. greater than or equal to D. less than or equal to
What is the correct boot sequence for a PC?
A. CPU, POST, power good, boot loader, operating system
B. POST, power good, CPU, boot loader, operating system
C. Power good, boot loader, CPU, POST, operating system
D. Power good, CPU, POST, boot loader, operating system