In SQL the statement select ∗ from R, S is equivalent to
2023
In SQL the statement select ∗ from R, S is equivalent to
Answer: B. Select ∗ from R cross join S — The SQL statement SELECT * FROM R, S performs an implicit Cartesian product between tables R and S. This operation generates all possible row combinations…
- A.
Select ∗ from R natural join S
- B.
Select ∗ from R cross join S
- C.
Select ∗ from R outer join S
- D.
Select ∗ from R inner join S
Attempted by 708 students.
Show answer & explanation
Correct answer: B
The SQL statement SELECT * FROM R, S performs an implicit Cartesian product between tables R and S. This operation generates all possible row combinations without any filtering conditions, which is functionally identical to an explicit CROSS JOIN statement in modern SQL standards.
Explore the full course: Iocl Engineers Officers Grade A Paper 2