Copyright

SQL: ISNULL Function

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. What is missing?

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. Using ISNULL to replace a NULL value with another value is used mainly in _____.

2. Examine the following code. What will the value of cost be if the statement finds a NULL value?

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

Answer these questions to see what you know about the ISNULL function in SQL. You will review your knowledge of specific uses for this function as well as the correct syntax.

Quiz & Worksheet Goals

In this quiz and worksheet you'll review your knowledge of:

  • Why you would use ISNULL for mathematical problems in SQL
  • Specific programs that use ISNULL in SQL
  • Correct syntax for this command

Skills Practiced

  • Problem solving - use acquired knowledge to correctly identify errors in strings of SQL code related to ISNULL
  • Information recall - access the knowledge you've gained regarding how to write ISNULL commands in SQL
  • Knowledge application - use your knowledge to answer questions about how ISNULL is used and what software suites it is most effective in

Additional Learning

To learn more about this command, read the lesson titled SQL: ISNULL Function.

  • Specific uses for ISNULL
  • What the expression is in SQL
  • What is moved to the SET statement
Support