Copyright

SQL Data Types: DECIMAL & NUMERIC

Instructions:

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

question 1 of 3

Which of these data types allow for decimals?

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. How should DECIMAL and NUMERIC be used in the same database?

2. What values need to be entered after selecting a data type (either NUMERIC or DECIMAL)?

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

Many types of programming languages have been developed to meet the many applications we use computer programs for. Use this assessment to test your understanding of SQL DECIMAL and NUMERIC languages, including what they allow you to do and their values.

Quiz & Worksheet Goals

With this assessment, you will test your understanding of:

  • Types of data that allow for decimals
  • How DECIMAL and NUMERIC should be used together
  • Values you need to enter after selecting a data type
  • What does 'p' and 's' stand for in DECIMAL and NUMERIC

Skills Practiced

Some of the skills covered in this assessment include:

  • Information recall - access the knowledge you've gained regarding what NUMERIC and DECIMAL data types allow for
  • Making connections - use understanding of NUMERIC and DECIMAL to answer a question about the way in which they work together
  • Knowledge application - use your knowledge to answer questions about different values of NUMERIC and DECIMAL languages

Additional Learning

With the lesson that accompanies this assessment, SQL Data Types: DECIMAL & NUMERIC, you will review information about the topics covered in the quiz/worksheet and more about:

  • The uses of NUMERIC and DECIMAL
  • Why they are different from other data types
  • The syntax of NUMERIC and DECIMAL data types
Support