GK Question

technology medium true_false

An outer join returns only the rows that have matching values in both tables.

  1. True
  2. False

Answer: False

INNER JOIN returns only matching rows. OUTER JOIN (LEFT/RIGHT/FULL) returns matching rows PLUS unmatched rows from one or both tables, with NULLs for missing side. LEFT JOIN: all left table rows; RIGHT JOIN: all right table rows; FULL OUTER: all rows from both. Essential for comprehensive data analysis and reporting.

Topic Database & Programming
Exam Relevance Banking, SSC JE, Railway
More in technology Back to all questions