Copyright

SQL: CASE Statement

Instructions:

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

question 1 of 3

What happens if you leave off the ELSE clause in an SQL CASE statement and not conditions are met?

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. Examine the following SQL statement. What will be displayed in the query if the artistID is 14?

2. Examine the following CASE statement. What is missing?

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

What is SQL? You can see what you know about this topic and CASE statements by using the worksheet and quiz.

Quiz & Worksheet Goals

Expect to see these topics on the multiple-choice quiz:

  • What the ELSE clause in a CASE statement is
  • Required parts of the CASE statement
  • SQL statements
  • What happens when you leave off the ELSE clause in an SQL CASE statement

Skills Practiced

  • Knowledge application - use your knowledge to answer questions about CASE statements
  • Information recall - access the knowledge you have gained about required parts of a CASE statement
  • Reading comprehension - ensure that you draw the most important details from the lesson on SQL conditional logic with CASE

Additional Learning

Complete the lesson titled SQL: CASE Statement to review more about these statements. You can use this lesson to cover these objectives:

  • Determine what SQL refers to
  • Learn how to use CASE statements the right way
  • Review examples of CASE statements
Support