πŸ“Š MySQL
Q. What are CROSS JOIN and JOIN are similar to?
  • (A) CARTESIAN JOIN
  • (B) NATURAL JOIN
  • (C) INNER JOIN
  • (D) OUTER JOIN
πŸ’¬ Discuss
βœ… Correct Answer: (C) INNER JOIN

Explanation: The joins ‘CROSS JOIN’ and ‘JOIN’ types are exactly similar to the ‘INNER JOIN’. The statements containing ‘INNER JOIN’ can replace it with ‘CROSS JOIN’ or ‘JOIN’ to get exactly the same result.

Explanation by: Nitin Gupta
The joins ‘CROSS JOIN’ and ‘JOIN’ types are exactly similar to the ‘INNER JOIN’. The statements containing ‘INNER JOIN’ can replace it with ‘CROSS JOIN’ or ‘JOIN’ to get exactly the same result.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
182
Total Visits
πŸ“½οΈ
4 y ago
Published
πŸŽ–οΈ
Nitin Gupta
Publisher
πŸ“ˆ
95%
Success Rate