In the buffer where there is no space for another block, the block can be inserted using

Related MCQs

•                                        frees the space occupied by a block as soon as the final tuple of that block has been processed.
• In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;
• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• If no header is specified, the block is said to be an                                PL/SQL block.
• Instead of locking index leaf nodes in a two-phase manner, some index concurrency- control schemes use                        on individual key values, allowing other key values to be inserted or deleted from the same leaf.
• Values of one type can be converted to another domain using which of the following?
• The file organization which allows us to read records that would satisfy the join condition by using one block read is
• The file organization which allows us to read records that would satisfy the join condition by using one block read is
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):