Question

The rule that allows transformation of a logical operation to a physical operation is called

(a) Logical equivalence rule

(b) Physical equivalence rule

(c) Memory equivalence rule

(d) None of the mentioned

This question was addressed to me in an online quiz.

My doubt is from Choice of Evaluation Plans topic in section Query Processing and Optimization of RDBMS

Answer 1

Correct answer is (b) Physical equivalence rule

For explanation I would say: The rule that allows transformation of a logical operation to a physical operation is called as a physical equivalence rule. It is a new class of equivalence rules.