SQL Data Types: REAL, FLOAT & DOUBLE Video

Instructions:

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

question 1 of 3

Using the float keyword, which statement will return all digits for the value 3.5872?

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. If you used the statement Float(5, 3) for the value 22.0009, what would SQL return?

2. Real, float, and double are considered _____ numbers

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 set will allow you to test your skills at using different commands in SQL. Questions will focus on the applications of these commands and their properties.

Quiz & Worksheet Goals

In this assessment, you'll test your abilities in:

  • What type of numbers real, float, and double are
  • Which data type store four bytes
  • What the statement Float(5, 3) would return

Skills Practiced

  • Reading comprehension - ensure that you draw the most important information from the material, such as the ability to utilize float, real and double to process data
  • Defining key concepts - ensure that you can accurately define main phrases, such as real, float, and double
  • Information recall - access the knowledge you've gained regarding what the statement Float(5, 3) would return in SQL

Additional Learning

If you would like to learn more about these commands, read the lesson titled SQL Data Type: REAL, FLOAT & DOUBLE. It will help you with topics such as:

  • Why these data types are considered to have an approximate value
  • Which type of data can hold eight bytes of data
  • Real world examples of these commands in use
Support