Multiple choice technology programming languages

Which of the following statements is true :

  1. inner join and intersect are same

  2. left join and union are same

  3. inner join when used with distinct can simulate intersect

  4. inner join and union are same
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

INTERSECT returns rows common to both queries. INNER JOIN returns matching rows from both tables based on a join condition. When you add DISTINCT to INNER JOIN, it removes duplicates, making it functionally equivalent to INTERSECT if the join conditions match on all columns. The other options are incorrect - UNION combines all rows (including duplicates), and joins are not equivalent to basic set operations.

Keep practicing — related questions