SQL: Full Outer Joins


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

Under what circumstance would you select a full outer join SQL statement?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. Given the following SQL statement, please describe what results will be given.

2. The results of a full outer join can be organized using an ORDER_BY clause; how would this be useful considering the examples given in the lesson?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

Join queries in SQL are used to bring together rows from two or more tables. The quiz covers reasons for why you would use a full outer join and the purpose of the ORDER_BY clause.

Quiz & Worksheet Goals

During the quiz, you will:

  • Point out the correct full outer join syntax
  • Identify a scenario where it would be wise to use a full outer join
  • Describe the results of a given SQL statement

Skills Practiced

  • Information recall - access the knowledge you've gained about circumstances that would require the use of a full outer join SQL statement
  • Interpreting information - verify that you can read information about the use of the ORDER_BY clause and interpret it correctly
  • Knowledge application - utilize your knowledge to give a reason for why you would choose a full outer join in SQL

Additional Learning

The lesson named SQL: Full Outer Joins will provide you with extra insight into this subject. This lesson discusses:

  • An advantage of using a full outer join to gather data
  • How to interpret the results of full outer join SQL statements
  • Why the ORDER_BY and WHERE clauses are useful for crafting SQL queries