SQL Fundamentals

Keep Unmatched Rows with OUTER JOIN

Choose LEFT, RIGHT, or FULL joins from the rows that must be preserved, then interpret unmatched columns and verify both matched and unmatched cases.

Beginner14 min read

SQL Fundamentals lessonRelational data foundationsProve

TIMED ASSESSMENT

Keep Unmatched Rows with OUTER JOIN

Questions and answer choices are randomized for every attempt. Everything needed to answer is shown on screen; no paper, calculator, terminal, server, or external test is required. Each answer is marked Correct or Incorrect, then locked until the final review.

15 questions20 min timer12/15 to pass

Explanations are hidden during the test. A full review is available only after submission.