SQL Data Types: CHAR & VARCHAR

Instructions:

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

question 1 of 3

Which of these CANNOT be stored in VARCHAR or CHAR records?

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 of these would NOT likely be stored using VARCHAR in SQL?

2. Which of these is a properly formatted CHAR example?

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

This quiz/worksheet examines SQL data types. The included questions focus on their storing capabilities and examples of their formatting.

Quiz & Worksheet Goals

This quiz/worksheet contains questions addressing:

  • The storage capacity of VARCHAR and CHAR records
  • Proper formatting of CHAR and VARCHAR
  • What would and wouldn't likely be stored with CHAR and VARCHAR

Skills Practiced

  • Distinguishing differences - ensure that you can differentiate between data that would and wouldn't likely be stored through VARCHAR and CHAR in SQL
  • Knowledge application - use your knowledge to identify correctly formatted examples of CHAR and VARCHAR
  • Information recall - access the knowledge you've gained regarding what VARCHAR and CHAR can and can't store

Additional Learning

To study these character strings in more detail, you can check out the accompanying lesson called SQL Data Types: CHAR & VARCHAR. This lesson involves the following objectives:

  • Know what CHAR characters can be composed of
  • Understand what distinguishes CHAR and VARCHAR
  • Learn how long character stings within VARCHAR can be
Support