Copyright

What is a Primary Key in SQL?

Instructions:

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

question 1 of 3

Which of these is likely a primary key for the DMV 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. What class of data are primary keys most often made?

2. What is the primary key most often used by health insurance companies and banks?

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

Primary keys are unique identifiers in SQL. The quiz includes questions about how primary keys are used, primary key requirements and primary keys that would be relevant to certain types of companies and organizations.

Quiz & Worksheet Goals

You will be tested on:

  • A primary key often used by banks and health insurance companies
  • Why a zip code would be a poor choice for a primary key in SQL
  • A probable primary key for a DMV database

Skills Practiced

  • Knowledge application - use your knowledge to point out the class of data that is typically used for primary keys
  • Information recall - access your understanding of primary key requirements
  • Interpreting information - verify that you can read information about the effectiveness of zip codes as primary keys and interpret it correctly

Additional Learning

View the lesson named What is a Primary Key in SQL? to supplement your knowledge of this subject. This lesson is centered on the following objectives:

  • Describe the code used to create a primary key in SQL
  • Identify the main advantage of primary keys in database management
  • Explain why primary keys are usually numeric values
Support