The                        policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.

Related MCQs

• The                                policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.
•                              policy allows multiple updates to accumulate on a block before it is output to stable storage, which can reduce the number of output operations greatly for frequently updated blocks.
• A concurrency-control policy such as this one leads to              performance since it forces transactions to wait for preceding transactions to finish before they can start.
• A                  on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
• In case the buffer manager do not write the blocks properly then the buffer manager uses
• The                is that part of main memory available for storage of copies of disk blocks.
• Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
•                      scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.
•                      are used to ensure that transactions access each data item in order of the transactions’          if their accesses conflict.
• Each of a pair of transactions has read data that is written by the other, but there is no data written by both transactions, is referred to as