If the SQL Statement SELECT C1,C2,C3

question 16

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
• E)C1,C2,and C3

---

Definitions:

Net Operating Income

The total profit of a business after subtracting operating expenses but before deducting taxes and interest.

Customers Served

The number of unique clients or customers that a business has provided products or services to within a specific period.

Variance

The difference between planned or expected results and actual results in financial and operational metrics.

Budgeting

The process of creating a plan to spend your money, creating an estimate of revenues and expenses over a specified period.