SQL: UNION vs. JOIN

Instructions:

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

question 1 of 3

Which is the best analogy to JOIN in SQL?

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. Which is the best analogy to UNION in SQL?

2. Which of these words WOULD NOT appear in a UNION command?

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

For this quiz and worksheet combination, you will be focusing on the comparison of UNION and JOIN in SQL. Questions will ask you about topics like the best analogy to JOIN, as well as a code that would tell a UNION command to not include duplicate values.

Quiz & Worksheet Goals

You can find the topics mentioned below in the quiz:

  • An analogy to UNION in SQL
  • Words that would not appear in a UNION command
  • Words not required in a JOIN command
  • Telling a UNION command to not include duplicate values

Skills Practiced

  • Defining key concepts - ensure that you can choose the word that would not be included in a JOIN command
  • Information recall - remember what you have learned about words appearing in a UNION command
  • Knowledge application - use what you know to answer questions about analogies to both commands

Additional Learning

To see more about the commands, click on the lesson titled SQL: UNION vs. JOIN, where you will find the following other topics:

  • Examples of UNION
  • Using JOIN
  • Command options
Support