Which of the Following Statements About Indexes Is Incorrect

question 115

Multiple Choice

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

---

Definitions:

Surplus

A situation in which the quantity of a good or service available exceeds the quantity demanded at the current price.

Loanable Funds

The total resources or funds available for borrowing in the financial markets, used for investments and other purposes.

Interest Rate

The cost of borrowing money or the return for investing, typically expressed as a percentage of the principal amount per annum.

Lend

The act of giving something, usually money, to someone with the expectation that it will be returned or repaid, often with interest.