Which of the Following Is Not True About the Difficulty

question 55

Multiple Choice

Which of the following is not true about the difficulty of index selection?

• A) The number of choices of indexes is linear in the number of columns
• B) The query optimizer may have subtle reasons not to use an index
• C) Values of parameters used in SQL statements of forms often vary from highly selective to not very selective
• D) Index choices can be interrelated in a subtle way

---

Definitions:

Reportable

Refers to information or data that must be disclosed or presented officially, often within financial statements or to regulatory bodies.

Reportable Segments

Portions of a business that can be separated for analysis and reporting purposes, typically based on certain criteria like products, services, or geographic locations.

Revenues

The cumulative sum of funds a business accrues from selling products or offering services over a specified duration.