Database Indexing Quiz Form
Test your knowledge of database indexing concepts. Please complete all questions to the best of your ability.
Full Name
*
First Name
Last Name
Email Address
*
example@example.com
Instructions
Which of the following best describes a database index?
*
A data structure that improves the speed of data retrieval operations
A method to store backup copies of data
A process for normalizing tables
A type of database user privilege
Select all statements that are true about clustered indexes.
*
A table can have only one clustered index
A clustered index determines the physical order of data in a table
Clustered indexes can be created on views
A table can have multiple clustered indexes
Match each index type to its typical use case.
*
Rows
Primary Key
Non-Clustered Index
Full-Text Index
Typical Use Case
Uniquely identifies each row
Speeds up full-text search
Reduces storage space
Improves sorting performance
Uniquely identifies each row
Speeds up full-text search
Reduces storage space
Improves sorting performance
Uniquely identifies each row
Speeds up full-text search
Reduces storage space
Improves sorting performance
Explain the difference between a unique index and a non-unique index.
*
What SQL command is used to create an index on a table?
*
Which scenario would benefit most from adding an index to a column?
*
A column frequently used in WHERE clauses
A column rarely queried
A column storing binary data
A column with only one unique value
List two potential drawbacks of using too many indexes on a table.
*
Submit Quiz
Should be Empty: