The replacement of a bad block generally is not totally automatic because

Related MCQs

• 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.
• The transaction can no longer continue with its normal execution because of some internal condition, such as bad input, data not found, overflow, or resource limit exceeded. This is
• An outstanding functionality of SQL is its support for automatic ………… to the target data.
• A block that is not allowed to be written back to disk is said to be                              
•                              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.
• Which level of RAID refers to disk mirroring with block striping?
• The file organization which allows us to read records that would satisfy the join condition by using one block read is
• A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by