Introduction to Advanced SQL Indexing Techniques
A beginner's guide to understanding advanced SQL indexing techniques.
Questions in this quiz
15 questions on Introduction to Advanced SQL Indexing Techniques. Work through them here, then start the quiz to answer them and see your score.
1.What is the primary purpose of an index in a SQL database?
- ATo manage user permissions
- BTo improve query performance
- CTo enforce data integrity
- DTo store data
2.Which type of index is created automatically by the database for a primary key?
- AClustered index
- BUnique index
- CNon-clustered index
- DFull-text index
3.What is a non-clustered index?
- AAn index that is used for full-text search
- BAn index that stores data within the table
- CAn index that is always unique
- DAn index that stores data separately from the table
4.Which SQL statement is used to create an index?
- ACREATE INDEX
- BALTER INDEX
- CUPDATE INDEX
- DINSERT INDEX
5.What is a covering index?
- AAn index that contains all the columns needed for a query
- BAn index that is used for backup
- CAn index that covers multiple tables
- DAn index that is automatically updated
6.Which of the following is a disadvantage of using indexes?
- ASimplified database design
- BImproved data integrity
- CIncreased storage requirements
- DFaster query performance
7.What is a composite index?
- AAn index that is automatically created
- BAn index that is always unique
- CAn index on a single column
- DAn index on multiple columns
8.Which index type is best for columns with a high degree of uniqueness?
- ANon-clustered index
- BUnique index
- CBitmap index
- DClustered index
9.What is the effect of indexing a column with many NULL values?
- AIt will automatically remove NULL values
- BIt will always improve performance
- CIt may not significantly improve performance
- DIt will decrease storage requirements
10.Which of the following is true about a full-text index?
- AIt is used for numeric calculations
- BIt is the same as a clustered index
- CIt is used for text-based searches
- DIt is automatically created for all text columns
11.What is the main benefit of using a bitmap index?
- AEfficient for columns with low cardinality
- BRequires no additional storage
- CAutomatically updates with data changes
- DEfficient for columns with high cardinality
12.How does a clustered index affect the physical order of data in a table?
- AIt reverses the physical order
- BIt has no effect on the physical order
- CIt randomizes the physical order
- DIt determines the physical order
13.Which of the following statements is true about indexing?
- AIndexes are automatically created for every column
- BIndexes reduce the size of the database
- CIndexes can slow down data modification operations
- DIndexes always speed up all types of queries
14.What is the purpose of a unique index?
- ATo ensure all values in a column are distinct
- BTo improve query performance for non-unique data
- CTo allow duplicate values in a column
- DTo store data in a separate table
15.What does the term 'index selectivity' refer to?
- AThe uniqueness of the index values
- BThe frequency of index updates
- CThe number of columns in the index
- DThe size of the index