1.

What are CROSS JOIN and JOIN are similar to?(a) INNER JOIN(b) NATURAL JOIN(c) OUTER JOIN(d) CARTESIAN JOIN

Answer» Correct answer is (a) INNER JOIN

Easiest 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.


Discussion

No Comment Found