Copyright

SQL: FORMAT Statement

Instructions:

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

question 1 of 3

Examine the following code. If the value for the column startDate is November 5, 2017, what will the result be after formatting?

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. What happens to the data in the table after a FORMAT statement is run?

2. Examine the following code. What will the pay rate look like after the FORMAT statement? (Assume the rate in the database is stored as 35.1230335).

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

You can quickly test what you know about the FORMAT command of SQL with this quiz/worksheet set. Questions will focus on reading code and interpreting commands.

Quiz & Worksheet Goals

In this set of worksheet questions you'll measure your understanding of:

  • How data is changed after Formatting
  • What will happen after specific code runs
  • Other names for a formatting command

Skills Practiced

  • Reading comprehension - ensure that you draw the most important information from the material, such as the correct syntax for a formatting command
  • Information recall - access the knowledge you've gained regarding what happens to data after a formatting command is run
  • Knowledge application - use your knowledge to examine given code regarding formatting commands

Additional Learning

If you're still curious about this command, read the lesson titled SQL: FORMAT Statement. It will help you with topics like:

  • Why FORMAT does not alter data
  • Examples of FORMAT syntax
  • Different types of SQL software suites
Support