ISRO 2024

Question

In SQL the statement $\text{select * from R, S}$ is equivalent to

1. $\text{select * from R natural join S}$
2. $\text{select * from R cross join S}$
3. $\text{select * from R outer join S}$
4. $\text{select * from R inner join S}$

Answer 1

By default, SQL performs cross product when no join is specified.

Hence the correct answer will be Option $(B)$ : select * from R cross join S