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

      Question

      In a database system, what is the primary purpose of

      creating an index on a table column?
      A To reduce the storage space of the table Correct Answer Incorrect Answer
      B To speed up data retrieval operations Correct Answer Incorrect Answer
      C To prevent data duplication Correct Answer Incorrect Answer
      D To encrypt sensitive data Correct Answer Incorrect Answer
      E To enforce referential integrity Correct Answer Incorrect Answer

      Solution

      Database indexes are specialized data structures that improve the speed of data retrieval operations on a database table at the cost of additional writes and storage space.

      Practice Next
      More IT Operating System Questions
      ask-question