__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

Related MCQs

• 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.
•                      is a contiguous group of
• 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.
• The                is that part of main memory available for storage of copies of disk blocks.
• In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• The                          scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.
• Drop Table cannot be used to drop a table referenced by a                    constraint.
• Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
• Drop Table cannot be used to drop a table referenced by a …………… constraint.