which increases the number of I/O operations needed to write a single logical block, pays a significant time penalty in terms of write performance.

Related MCQs

•                              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.
• In the buffer where there is no space for another block, the block can be inserted using
•                                        frees the space occupied by a block as soon as the final tuple of that block has been processed.
• If no header is specified, the block is said to be an                                PL/SQL block.
• Designers use which of the following to tune the performance of systems to support time-critical operations?
• ARIES supports                        operations, which are physical in that the affected page is physically identified, but can be logical within the page.
• A                  is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
• A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
• Designers use which of the following to tune the performance of systems to support timecritical operations?
• Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.