Home »
MCQs »
DBMS MCQs
DBMS Evaluation of Expressions MCQs
DBMS Evaluation of Expressions MCQs: This section contains multiple-choice questions and answers on Evaluation of Expressions in DBMS.
Submitted by Anushree Goswami, on May 14, 2022
1. A computation of each operation is done one by one when evaluating an expression containing ___ operations.
- One
- Two
- Three
- Multiple
Answer: D) Multiple
Explanation:
A computation of each operation is done one by one when evaluating an expression containing multiple operations.
Discuss this Question
2. How many methods do we use to evaluate an expression carrying multiple operations in query processing system?
- 1
- 2
- 3
- 4
Answer: B) 2
Explanation:
We use 2 methods to evaluate an expression carrying multiple operations in query processing system.
Discuss this Question
3. What is/are the method(s) we use to evaluate an expression carrying multiple operations in query processing system?
- Materialization
- Pipeling
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
The methods we use to evaluate an expression carrying multiple operations in query processing system are -
- Materialization
- Pipelining
Discuss this Question
4. When evaluating ____ relational operation at a time, the expression evaluates the materialization method.
- One
- Two
- Three
- Multiple
Answer: A) One
Explanation:
When evaluating one relational operation at a time, the expression evaluates the materialization method.
Discuss this Question
5. A ___ is determined for each operation in materialization.
- Sequence
- Order
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
A sequence or order is determined for each operation in materialization.
Discuss this Question
6. A ___ relation is created for storage and use of the outputs after all the operations have been evaluated.
- Permanent
- Temporary
- Primary
- Secondary
Answer: B) Temporary
Explanation:
A temporary relation is created for storage and use of the outputs after all the operations have been evaluated.
Discuss this Question
7. The materialization method has the disadvantage of requiring one to construct temporary relations between the evaluated operations and the results that they produce, respectively.
- Advantage
- Disadvantage
- Pros
- None
Answer: B) Disadvantage
Explanation:
This materialization method has the disadvantage of requiring one to construct temporary relations between the evaluated operations and the results that they produce, respectively.
Discuss this Question
8. Unless they are small in size, temporary relations are written to ___.
- Disk
- System
- Array
- Log
Answer: A) Disk
Explanation:
Unless they are small in size, temporary relations are written to disk.
Discuss this Question
9. In a pipeline, it allows comparison of each ___ operation within an expression simultaneously.
- Relational
- Analytical
- Algebraic
- None
Answer: A) Relational
Explanation:
In a pipeline, it allows comparison of each relational operation within an expression simultaneously.
Discuss this Question
10. When an operation is evaluated, its ___ is passed on to the next one, and this process continues until each relational operation has been evaluated thoroughly.
- Input
- Output
- Process
- None
Answer: B) Output
Explanation:
When an operation is evaluated, its output is passed on to the next one, and this process continues until each relational operation has been evaluated thoroughly.
Discuss this Question
11. ___ does not require the storage of temporary relationships.
- Evaluation
- Materialization
- Pipelining
- None
Answer: C) Pipelining
Explanation:
Pipelining does not require the storage of temporary relationships.
Discuss this Question