What is a Foreign Key in SQL?


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

question 1 of 3

What is the main way to absolutely recognize a record within a database?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 83,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 does a foreign key do?

2. Which of these would likely be used as a foreign key between a table on student enrollment and student grades?

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

Quickly assess your knowledge of the foreign keys used in SQL. Questions will focus on what foreign keys do and the difference between primary keys and foreign keys.

Quiz & Worksheet Goals

This quiz will help you review topics like:

  • The main way to recognize a record in a database
  • What a foreign key does
  • The name of the relationship between tables that can occur when using a foreign key

Skills Practiced

  • Defining key concepts - ensure that you can accurately define main phrases, such as foreign key
  • Distinguishing differences - compare and contrast topics from the lesson, such as what is true about primary keys but not always for foreign keys
  • Knowledge application - use your knowledge to answer questions about the relationship between tables that results from using a foreign key

Additional Learning

Learn the uses of foreign keys in SQL using the lesson titled What is a Foreign Key in SQL. The material will cover topics such as:

  • Why foreign keys are so useful on subordinate tables
  • Real world examples of primary and foreign keys
  • How they can apply to multiple tables