frees the space occupied by a block as soon as the final tuple of that block has been processed.

Related MCQs

• A                    integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• In the buffer where there is no space for another block, the block can be inserted using
• _______ allow us to identify uniquely a tuple in the relation.
• _______ allow us to identify uniquely a tuple in the relation.
• A            is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
• The           operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
• The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
• If there are n tuples in the partition and the rank of the tuple is r, then its                  is defined as (r −1)/(n−1).