Copyright

SQL DROP View: Tutorial & Overview

Instructions:

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

question 1 of 3

Which optional statement tells the DROP VIEW command to work only if the view is present in the database?

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. Which of the following is the correct syntax for dropping/deleting the View Customer_View?

2. What item(s) does the DROP VIEW command delete?

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

There are a wide range of nuances and applications for SQL, and this quiz will determine whether you understand SQL DROP View statements. Questions on the quiz will ask you about specific commands, the necessary syntax, and queries.

Quiz & Worksheet Goals

These evaluation tools can assess how much you recall about:

  • An optional statement to use only if the view is present in the database
  • The proper syntax for dropping/deleting the View Customer_View
  • Item/items deleted by the DROP VIEW command
  • What happens when a query tries to run a view that has been dropped
  • Definition of a View

Skills Practiced

This worksheet and quiz let you work on the following skills:

  • Critical thinking - apply relevant concepts to examine information about DROP View statements in a different light
  • Defining key concepts - ensure that you can accurately define main phrases, such as optional statement and DROP commands
  • Knowledge application - use your knowledge to answer questions about the meaning of the term View

Additional Learning

Discover more facts about this topic with the following lesson, SQL DROP View: Tutorial & Overview. Use the lesson for help with the quiz questions, and to learn the following:

  • Benefits of the View tool
  • Basic syntax for SQL View and related commands
  • Applications of the DROP command
Support