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


    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
    ask-question