Theta join operations are
(a) Commutative
(b) Associative
(c) Distributive under projection
(d) All of the mentioned
This question was addressed to me in a job interview.
My question comes from Transformation of Relational Expressions topic in portion Query Processing and Optimization of RDBMS