Selection Operation in Query Processing Multiple Choice Questions (MCQ) PDF Download

MCQ 1: A3 search performs retrieval of multiple records by using a primary index specifying the

1. Equality comparison on a key attribute
2. Inequality comparison on a nonkey attribute
3. Equality comparison on a nonkey attribute
4. Inequality comparison on a key attribute

MCQ 2: In A4 search algorithm, selection operation can specify an equality condition by using a

1. Secondary index
2. Clustered index
3. Nonclustered index
4. Primary index

MCQ 3: In the A2 search, the index is used to retrieve a single record that meets the corresponding

1. Equality comparison
2. Index condition
3. Nonkey comparison
4. Inequality comparison

MCQ 4: Multiple records can be retrieved by using the

1. Secondary index
2. Primary index
3. Cluster index
4. Scrub index

MCQ 5: The A2 search algorithm operates on an equality comparison on a key attribute with a

1. Secondary index
2. Primary index
3. Access path
4. Nonkey comparison