📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • ✖

      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