Question

Which type of SQL JOIN returns all rows from the left table, and the matched rows from the right table (with NULLs where there is no match)?

A INNER JOIN
B RIGHT JOIN
C LEFT JOIN
D FULL OUTER JOIN
E CROSS JOIN
Practice Next

Hey! Ask a query

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)