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.

Computer Science & Information Technology

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/

Computer Science & Information Technology

Which of the following is the escape character?

a. * b. \ c. \n d. "

Computer Science & Information Technology

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

Computer Science & Information Technology

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

Computer Science & Information Technology