📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    Question

    Which of the following statements about SQL `INDEXES` is

    generally TRUE?
    A Indexes always improve the performance of all `INSERT`, `UPDATE`, and `DELETE` operations. Correct Answer Incorrect Answer
    B A table can have only one index. Correct Answer Incorrect Answer
    C Indexes are primarily used to speed up data retrieval operations (`SELECT` queries). Correct Answer Incorrect Answer
    D Indexes consume no storage space and require no maintenance. Correct Answer Incorrect Answer
    E Indexes are automatically created for every column in a table by default. Correct Answer Incorrect Answer

    Solution

    Indexes are primarily used to speed up data retrieval operations (`SELECT` queries).

    Practice Next
    More SQL Questions
    ask-question