Google News
logo
MySQL - Quiz(MCQ)
CROSS JOIN and JOIN are similar to ______
A)
OUTER JOIN
B)
NATURAL JOIN
C)
CARTESIAN JOIN
D)
INNER JOIN

Correct Answer :   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.

Advertisement