Question

The result of each intermediate operation are created and then are used for valuation of the next level operations, this evaluation is called as ________

(a) Chain evaluation

(b) Pipeline evaluation

(c) Materialized evaluation

(d) Demand driven evaluation

I got this question in final exam.

My question is from Evaluation of Expressions in section Query Processing and Optimization of RDBMS

Answer 1

Correct choice is (c) Materialized evaluation

To explain I would say: The result of each intermediate operation are created and then are used foe valuation of the next level operations, this evaluation is called as Materialized evaluation. This is not space effective as we need to construct the temporary relations which must be written to a disk.