In a                          the system scans each file block and tests all records to see whether they satisfy the selection condition.

Related MCQs

• The        algorithm scans each index for pointers to tuples that satisfy an individual condition.
• 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
• If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by
• The          connective tests for set membership, where the set is a collection of values produced by a select clause. The           connective tests for the absence of set membership.
• Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?
• 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 strategy can retrieve a single record if the equality condition is on a key; multiple records may be retrieved if the indexing field is not a key is