SQL Data Types: INT & SMALLINT

Instructions:

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

question 1 of 3

In Structured Query Language (SQL), how many bytes of information does SMALLINT hold?

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. In Structured Query Language (SQL), how many potential values can be held by TINYINT?

2. In Structured Query Language (SQL), about how many values can INT hold?

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 these questions to test yourself on SQL data fields. Questions will focus on the size of specific fields and goals of database developers.

Quiz & Worksheet Goals

This assessment will test your knowledge and understanding of:

  • How many bytes of data does SMALLINT hold in SQL
  • Why a user might want to limit the size of integers
  • How many values INT can hold in SQL

Skills Practiced

  • Defining key concepts - ensure that you can accurately define main phrases, such as SMALLINT and TINYINT
  • Information recall - access the knowledge you've gained regarding how many bytes a BIGINT entry permits
  • Knowledge application - use your knowledge to answer questions about why a user might want to limit the size of integers

Additional Learning

Get a more in depth understanding of these concepts using the lesson titled SQL SQL Data Type: INT & SMALLINT. It will help you cover topics like:

  • Why it is the blank rather than the number that is important
  • Why INT is one of the first data fields database developers learn
  • What MEDIUMINT allows
Support