ExamCompetition Your Success, Our Mission
Login Register
Question discussion

Which SQL join returns all rows from both tables, filling the columns of the non-matching side with NULL?

1753Medium DSSSB TGT Computer Science 0 replies 1 views
0

Which SQL join returns all rows from both tables, filling the columns of the non-matching side with NULL?

  • AINNER JOIN
  • BLEFT OUTER JOIN
  • CFULL OUTER JOIN
  • DCROSS JOIN
Correct answer: C

Explanation

A full outer join keeps the unmatched rows from both tables, padding the missing side with NULLs.
Join the discussion Report an error

Discussion 0

Nobody has replied yet. Start the discussion!