QuizzesFundamentals of SQL Indexing for Beginners
beginner
databases

Fundamentals of SQL Indexing for Beginners

An introductory quiz on SQL indexing techniques for beginners.

15 minutes 15 questions Pass at 70%
Time Limit
15 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

Questions in this quiz

15 questions on Fundamentals of SQL Indexing for Beginners. Work through them here, then start the quiz to answer them and see your score.

  1. 1.What is the primary purpose of an index in a SQL database?

    • ATo enforce data integrity
    • BTo store data redundantly
    • CTo manage user permissions
    • DTo speed up query performance
  2. 2.Which type of index is automatically created with a primary key?

    • AUnique Index
    • BClustered Index
    • CFull-text Index
    • DNon-clustered Index
  3. 3.What is a non-clustered index?

    • AAn index that combines multiple columns
    • BAn index that stores data rows in the leaf nodes
    • CAn index that does not alter the physical order of the rows
    • DAn index that is always unique
  4. 4.Which SQL statement is used to create an index?

    • ACREATE INDEX
    • BADD INDEX
    • CINSERT INDEX
    • DNEW INDEX
  5. 5.What is a composite index?

    • AAn index that is always clustered
    • BAn index on a single column
    • CAn index that is automatically created
    • DAn index on multiple columns
  6. 6.How does a clustered index affect the table data?

    • AIt changes the physical order of the data
    • BIt compresses the data
    • CIt encrypts the data
    • DIt duplicates the data
  7. 7.Which of the following is a disadvantage of using indexes?

    • AIncreased query performance
    • BReduced storage space
    • CSlower data modification operations
    • DSimplified data retrieval
  8. 8.What is the maximum number of non-clustered indexes you can have per table in SQL Server?

    • A256
    • B999
    • C64
    • D16
  9. 9.Which index type is best for full-text searches?

    • AFull-text Index
    • BUnique Index
    • CNon-clustered Index
    • DClustered Index
  10. 10.What command would you use to remove an index in SQL?

    • AREMOVE INDEX
    • BDROP INDEX
    • CALTER INDEX
    • DDELETE INDEX
  11. 11.Which of the following can be indexed?

    • ARows
    • BViews
    • CColumns
    • DTables
  12. 12.What is the impact of indexing on disk space?

    • AIncreases disk space usage
    • BCompresses the data
    • CDecreases disk space usage
    • DNo impact on disk space
  13. 13.Which index type ensures that no duplicate values are entered in a column?

    • AClustered Index
    • BFull-text Index
    • CNon-clustered Index
    • DUnique Index
  14. 14.What is the default index type created with a primary key in MySQL?

    • AUnique Index
    • BNon-clustered Index
    • CClustered Index
    • DFull-text Index
  15. 15.Which SQL clause can benefit significantly from indexing?

    • AGROUP BY
    • BORDER BY
    • CAll of the above
    • DWHERE