DataSys+ Index Management and Optimization Quiz

1. True or False: Index reorganization requires the table to be locked during the operation.

True

False

2. Which index statistic tracks the density of distinct values in an indexed column?

Cardinality

Selectivity

Distribution

Histogram

3. True or False: Unique indexes enforce referential integrity between tables.

True

False

4. What percentage of fragmentation typically triggers a rebuild rather than reorganization?

5-10%

10-20%

30% or higher

50% or higher

Submit

6. Which monitoring tool helps identify missing indexes that could improve query performance?

Query Store

Execution Plan Analyzer

Dynamic Management Views (DMVs)

All of the above

7. True or False: Covering indexes can eliminate the need to access the base table for query results.

True

False

Submit

9. Which query execution plan metric indicates the effectiveness of an index?

Seek operations

Scan operations

CPU time

Memory allocation

Submit

11. What is the primary purpose of creating an index on a database table?

To reduce storage space

To speed up data retrieval and query execution

To automatically backup data

To encrypt sensitive information

12. What is the main disadvantage of creating too many indexes on a table?

Increased query performance

Slower INSERT, UPDATE, and DELETE operations

Reduced storage requirements

Improved data consistency

Submit

14. Which of the following statements about nonclustered indexes is correct?

A table can have only one nonclustered index

Nonclustered indexes contain a copy of indexed columns and a row locator

Nonclustered indexes determine the physical row order

Nonclustered indexes cannot include NULL values

Submit

16. True or False: A clustered index determines the physical order of rows in a table.

True

False

17. Which maintenance operation rebuilds an index from scratch?

Index defragmentation

Index reorganization

Index rebuild

Index statistics update

18. What is index fragmentation?

The physical splitting of index pages due to insertions and deletions

The process of compressing index data

The encryption of index metadata

The replication of indexes across servers

Submit

20. Which index type uses a tree structure to organize key values hierarchically?

Hash index

Bitmap index

B-tree index

Full-text index

DataSys+ Index Management and Optimization Quiz

1. True or False: Index reorganization requires the table to be locked during the operation.

2.

What first name or nickname would you like us to use?

2. Which index statistic tracks the density of distinct values in an indexed column?

3. True or False: Unique indexes enforce referential integrity between tables.

4. What percentage of fragmentation typically triggers a rebuild rather than reorganization?

5. Index ______ is a lightweight maintenance operation that defragments index leaf pages.

6. Which monitoring tool helps identify missing indexes that could improve query performance?

7. True or False: Covering indexes can eliminate the need to access the base table for query results.

8. What is index ______, which occurs when modifications cause index pages to be scattered across disk?

9. Which query execution plan metric indicates the effectiveness of an index?

10. A ______ index is used to quickly locate rows based on exact value matches.

11. What is the primary purpose of creating an index on a database table?

12. What is the main disadvantage of creating too many indexes on a table?

13. Index ______ refers to the process of updating index statistics to reflect data changes.

14. Which of the following statements about nonclustered indexes is correct?

15. What does a ______ index allow you to search text content within columns?

16. True or False: A clustered index determines the physical order of rows in a table.

17. Which maintenance operation rebuilds an index from scratch?

18. What is index fragmentation?

19. A ______ index is optimized for queries that search on multiple columns together.

20. Which index type uses a tree structure to organize key values hierarchically?