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


    Question

    What is a significant disadvantage of having too many

    indexes on a database table?
    A Slower read operations Correct Answer Incorrect Answer
    B Increased data integrity issues Correct Answer Incorrect Answer
    C Slower write (insert, update, delete) operations Correct Answer Incorrect Answer
    D Reduced security Correct Answer Incorrect Answer
    E Inability to perform joins Correct Answer Incorrect Answer

    Solution

    Every time data is inserted, updated, or deleted in the main table, the corresponding indexes must also be updated. This overhead can significantly slow down write operations if there are many indexes.

    Practice Next
    ask-question