📊 MySQL
Q. What is the join where all possible row combinations are produced?
  • (A) CARTESIAN
  • (B) NATURAL
  • (C) OUTER
  • (D) INNER JOIN
💬 Discuss
✅ Correct Answer: (A) CARTESIAN

Explanation: In ‘cartesian product’, each row of each table is combined with each row in every other table to produce all possible combination. This produces a very large number of rows since the number is the product of rows.

Explanation by: Nitin Gupta
In ‘cartesian product’, each row of each table is combined with each row in every other table to produce all possible combination. This produces a very large number of rows since the number is the product of rows.

💬 Discussion

📊 Question Analytics

👁️
169
Total Visits
📽️
3 y ago
Published
🎖️
Nitin Gupta
Publisher
📈
90%
Success Rate