Copyright

SQL: INSERT Statement

Instructions:

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

question 1 of 3

Which statement will correctly insert a new record into the genre table?

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. INSERT is part of a categorization of SQL statements called _____

2. You can insert multiple rows into the table by adding _____ to the INSERT statement.

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

Use this quiz and worksheet to check how much you know about using the INSERT statement in SQL databases. You'll review how to properly write the statement and common rules.

Quiz & Worksheet Goals

With this quiz and worksheet, you'll review:

  • How to correctly insert a record
  • What type of language the INSERT statement is
  • How field names relate to the values
  • Common rules around using the INSERT statement

Skills Practiced

  • Information recall - revisit what you know about SQL and using the INSERT statement
  • Knowledge application - check what you know about the INSERT statement to be able to answer questions about the correct use
  • Making connections - see if you can remember the INSERT statement and how to use it correctly

Additional Learning

Looking for a deeper review of this topic? Check out the provided lesson, SQL: INSERT Statement to learn more about:

  • Basic syntax for the INSERT statement
  • Inserting multiple records at once
  • Examples of the INSERT statement
Support