Q. What does a RIGHT JOIN operation return?

A
Only matching rows from both tables
B
All rows from the right table and matching rows from the left
C
All rows from the left table
D
Only non-matching rows
Solution:

RIGHT JOIN returns all rows from the right table and the matching rows from the left table, with NULLs for non-matches.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!