Question

The join orders where the right operand of each join is in one of the initial relations are called as ________

(a) Right deep join orders

(b) Left deep join orders

(c) Outer join orders

(d) None of the mentioned

I had been asked this question in an interview for internship.

This intriguing question originated from Choice of Evaluation Plans in chapter Query Processing and Optimization of RDBMS

Answer 1

Correct option is (b) Left deep join orders

For explanation I would say: The join orders where the right operand of each join is in one of the initial relations are called as left deep join orders.