Copyright

Index Fragmentation in SQL

Instructions:

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

question 1 of 3

Which of the following is NOT a characteristic of SQL?

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 NOT a SQL command?

2. How many indexes can a database have?

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

Determine what you understand about index fragmentation in SQL with these study assessments. You'll be tested on areas of study such as the characteristics of SQL and types of SQL commands.

Quiz & Worksheet Goals

Test yourself on the following:

  • The number of indexes in a database
  • The advantage of an index
  • Number of fragments in a given index after deleting some values

Skills Practiced

  • Information recall - access the knowledge you've gained regarding the characteristics of SQL
  • Knowledge application - use your knowledge to answer questions about index advantages
  • Reading comprehension - ensure that you draw the most important information from the related lesson on index fragmentation in SQL

Additional Learning

Learn more about this area of study with the lesson entitled Index Fragmentation in SQL, which will cover the following topics:

  • What SQL stands for and what it does
  • The definition of fragmentation
  • How computers are able to access information so quickly
Support