Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 28 of 91

JOINS and SET Operations — Question 4

Back to all questions
4
Question

Question 4

Which product is returned in a join query having no join condition ?

  1. Equi-join
  2. Cartesian
  3. Both Equijoins and Cartesian
  4. Natural
Answer

Cartesian

Reason — When a join query has no join condition specified, it results in a Cartesian product. This means that every row from the first table is combined with every row from the second table.