Query Processing Multiple Choice Questions (MCQ) PDF Download

MCQ 1: An operation of relational algebra annotated with instructions on how to evaluate it is called an

1. Execution plan
2. Query plan
3. Evaluation primitive
4. Execution engine

MCQ 2: The tasks involved in extracting some kind of data from a database known as

1. Query processing
2. Query management
3. Query statement
4. Query transaction

MCQ 3: Before any processing on a query can begin, it must be

1. Accessed
2. Evaluated
3. Optimized
4. Translated

MCQ 4: A sequence of primitive operations that can be used to evaluate a query is a

1. Query-execution plan
2. Query-evaluation plan
3. Both A and B
4. Query-execution engine

MCQ 5: After the query plan is chosen, the query is

1. Executed
2. Evaluated
3. Interpreted
4. Implemented