SQL: CREATE Index

Instructions:

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

question 1 of 3

What is the purpose of a UNIQUE clause in a CREATE INDEX statement?

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 code. What is a drawback to the use of UNIQUE?

2. Examine the following code. What is being indexed?

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

To master SQL, there are many things you need to learn, and this quiz will measure your level of understanding of the SQL CREATE Index. Questions on the quiz will ask you to identify the importance of the index and the proper way to use the index code. You will also need to interpret lines of SQL CREATE Index code.

Quiz & Worksheet Goals

Use these assessment tools to determine your knowledge of:

  • UNIQUE clause
  • The downsides to the use of UNIQUE
  • How codes index different items
  • Recognizing proper codes for desired results
  • Situations that do not work well with indexing

Skills Practiced

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

  • Reading comprehension - ensure that you draw the most important information from the related SQL CREATE index lesson
  • Critical thinking - apply relevant concepts to examine information about the UNIQUE clause and its drawbacks in a different light
  • Interpreting information - verify that you can read information regarding what can be indexed and interpret it correctly

Additional Learning

Gain more insight into this topic by reviewing the connected lesson, SQL: CREATE Index. You can find all of the answers to the quiz questions within the lesson, as well as the following information:

  • Definition and basic purposes of making the index
  • Considerations for indexing
  • Practical examples of indexing
Support