If the SQL Statement SELECT C1,C2,C3

question 79

Multiple Choice

If the SQL statement SELECT C1,C2,C3
FROM T4
WHERE C2 = 'Smith';
Is frequently executed,which column(s) should be considered for indexing based only on the statement itself?

• A)C1 only
• B)C2 only
• C)C3 only
• D)C1 and C2

---

Definitions:

Interest Expense

The cost incurred by an entity for borrowed funds, typically reported on the income statement.

Compounded Annually

Interest on an investment or loan that is calculated once a year, adding to the principal sum for the next year.

Present Value

The present-day worth of money to be received in the future or ongoing cash flows, discounted by a specific rate of return.

Single Sum

A lump-sum amount of money taken in a single payment rather than in installments over time.