Multiple choice technology databases

Which is not a valid join?

  1. Equi Join

  2. Natural Join

  3. Left Inner Join

  4. Cartesian product
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

'Left Inner Join' is not a valid join type in SQL. Inner join returns rows matching in both tables; left outer join returns all rows from left table plus matches. Combining 'Left' and 'Inner' is contradictory. Valid joins include Equi Join, Natural Join, and Cartesian product (cross join).

Keep practicing — related questions