Refer to the statements given below and identify which of the following is correct. Statement 1: Without any indexes - the database uses a lot of disk I/O and can effectively pollute the disk cache. Statement 2: Some extra disk space and a bit of CPU overhead is sacrificed on each INSERT - UPDATE - and DELETE query while using indexes.

🎲 Try a Random Question  |  Total Questions in Quiz: 63  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
LAMP Test — practice the complete quiz, review flashcards, or try a random question.


Refer to the statements given below and identify which of the following is correct. Statement 1: Without any indexes - the database uses a lot of disk I/O and can effectively pollute the disk cache. Statement 2: Some extra disk space and a bit of CPU overhead is sacrificed on each INSERT - UPDATE - and DELETE query while using indexes.