Database Indexing: Types and Performance Optimization Insights
Explore intermediate concepts of database indexing and how they optimize performance.
Questions in this quiz
12 questions on Database Indexing: Types and Performance Optimization Insights. Work through them here, then start the quiz to answer them and see your score.
1.What is the primary purpose of a database index?
- ATo speed up query performance
- BTo encrypt data
- CTo increase storage space
- DTo ensure data integrity
2.Which type of index is best suited for a column with a high number of unique values?
- AHash index
- BB-tree index
- CFull-text index
- DBitmap index
3.How does a hash index differ from a B-tree index?
- AB-tree indexes use more storage space
- BB-tree indexes are slower for equality queries
- CHash indexes are faster for range queries
- DHash indexes are ideal for equality searches
4.Which of the following is a disadvantage of using indexes?
- AIncreased query performance
- BImproved data integrity
- CIncreased storage requirements
- DReduced data redundancy
5.What is a composite index?
- AAn index that combines multiple columns
- BAn index that is automatically created by the database
- CAn index that uses hashing
- DAn index on a single column
6.Why might a database administrator choose to drop an index?
- ATo increase data redundancy
- BTo reduce storage space
- CTo improve query performance
- DTo enhance data encryption
7.Which index type is most suitable for a column storing text data for search purposes?
- AHash index
- BBitmap index
- CFull-text index
- DB-tree index
8.What is the impact of indexing on data modification operations like INSERT, UPDATE, and DELETE?
- AImproves data integrity
- BSlows down data modification
- CSpeeds up data modification
- DNo impact
9.In which scenario would a bitmap index be most effective?
- ALow cardinality columns
- BNumeric range queries
- CText search columns
- DHigh cardinality columns
10.What is the role of a clustered index in a database?
- ATo store data in a random order
- BTo encrypt data
- CTo store data in the order of the index
- DTo create a backup of the data
11.How does indexing affect the execution plan of a query?
- AIt has no effect
- BIt always increases the execution time
- CIt can change the join order
- DIt prevents the use of subqueries
12.What is an index scan?
- AA scan that ignores the index
- BA scan of index entries to find matching rows
- CA full table scan
- DA scan of the entire index