Which of the following statements about indexes is incorrect?
A) An index is a database object that stores a frequently referenced value and the row id (ROWID)of the record containing that value.
B) An index is only beneficial if a large percentage of a table is expected to be returned in query results.
C) An index is used to speed up the process of searching for specific data.
D) An index is updated automatically every time a DML operation is performed on the

Question

Quizplus · Accepted Answer

Indexes are most beneficial when a small percentage of a table is returned in query results, as they help in quickly locating the rows. Statement B is incorrect because it suggests the opposite.

Which of the Following Statements About Indexes Is Incorrect