Database Indexing Strategies: Boosting Query Performance
Learn the basics of database indexing strategies to enhance query performance.
Questions in this quiz
15 questions on Database Indexing Strategies: Boosting Query Performance. 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 store data
- BTo secure the database
- CTo improve query performance
- DTo backup data
2.Which type of index is typically used to enforce uniqueness in a column?
- AFull-text index
- BNon-clustered index
- CUnique index
- DClustered index
3.What is a clustered index?
- AAn index that is not stored in any particular order
- BAn index that sorts and stores the data rows in the table based on their key values
- CAn index used for full-text search
- DAn index that stores a separate copy of data
4.Which statement is true about non-clustered indexes?
- AThey create a separate structure to hold the index data
- BThey store data in the same order as the table
- CThey can exist only once per table
- DThey cannot be used with unique constraints
5.What is the main disadvantage of having too many indexes on a table?
- AIncreased storage space usage
- BIncreased query performance
- CFaster data retrieval
- DImproved data integrity
6.Which type of index is most suitable for a column frequently used in search queries?
- AHash index
- BFull-text index
- CNon-clustered index
- DBitmap index
7.What happens if a table has no indexes?
- AData is more secure
- BData retrieval is impossible
- CQueries run faster
- DQueries may perform full table scans
8.How does a composite index differ from a single-column index?
- AIt indexes multiple columns together
- BIt cannot be used in queries
- CIt is slower than a single-column index
- DIt indexes only one column
9.Which index type is best for a column with a high number of distinct values?
- AHash index
- BBitmap index
- CClustered index
- DUnique index
10.What is the effect of an index on data insertion operations?
- ASpeeds up insertion
- BPrevents insertion
- CHas no effect
- DSlows down insertion
11.Which type of index is specifically designed for text data?
- ABitmap index
- BClustered index
- CFull-text index
- DHash index
12.When should you avoid using an index?
- AOn primary key columns
- BOn columns used in JOIN operations
- COn columns frequently used in WHERE clauses
- DOn columns with low cardinality
13.What is the role of a primary key index?
- ATo store data in a random order
- BTo allow duplicate values
- CTo enforce a unique constraint on a column
- DTo prevent data retrieval
14.Which index type is most suitable for columns used in aggregate functions?
- AFull-text index
- BBitmap index
- CNon-clustered index
- DClustered index
15.What is the main benefit of using a hash index?
- AFast equality checks
- BReduced storage space
- CEfficient range queries
- DImproved text search