SQL: Left & Right Joins

Instructions:

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

question 1 of 3

Which type of database supports SQL LEFT and RIGHT Joins?

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. What is the intent of a SQL JOIN?

2. Which of the following is not true of a SQL LEFT JOIN?

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

Inside this quiz and worksheet combo, you are looking at LEFT and RIGHT JOIN as they are used in SQL. Questions ask about the type of database that supports JOIN as well as the difference between LEFT and RIGHT in the JOIN command.

Quiz & Worksheet Goals

You can find the following topics in question form during the quiz:

  • The reason for using JOIN
  • Characteristics of LEFT JOIN
  • Example of the structure of a JOIN
  • The difference between LEFT and RIGHT

Skills Practiced

  • Information recall - remember what you have learned about the characteristics of a LEFT JOIN
  • Knowledge application - use what you know to answer questions about the structure of a JOIN
  • Distinguishing differences - compare and contrast LEFT and RIGHT JOIN

Additional Learning

For more help with the commands, check out the lesson titled SQL: Left & Right Joins, where you can look into the following other topics:

  • The ON command
  • Database examples
  • Examples of code
Support