Locks on buffer blocks are unrelated to locks used for concurrency-con – McqOptions

MCQOPTIONS

1.	Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This i?
A.	Latches
B.	Swap Space
C.	Dirty Block
D.	None of the mentioned
Answer» B. Swap Space

Discussion

No Comment Found

Related MCQs

THE_OPERATING_SYSTEM_RESERVES_SPACE_ON_DISK_FOR_STORING_VIRTUAL-MEMORY_PAGES_THAT_ARE_NOT_CURRENTLY_IN_MAIN_MEMORY;_THIS_SPACE_IS_CALLED?$
THE____________________CONTAINS_A_LIST_OF_BLOCKS_THAT_HAVE_BEEN_UPDATED_IN_THE_DATABASE_BUFFER.?$
Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This i?
The ___________ policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.
______________ 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.
The _______________ policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.
Writing the buffered log to __________ is sometimes referred to as a log force.
Before a block of data in main memory can be output to the database, all log records pertaining to data in that block must have been output to stable storage. This is
The order of log records in the stable storage ____________ as the order in which they were written to the log buffer.
In order to reduce the overhead in retrieving the records from the storage space we use