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:

Quality

The degree to which a set of inherent characteristics fulfills requirements.

Stockholders' Equity

The residual interest in the assets of a corporation that remains after deducting its liabilities, representing the ownership interest of shareholders in the company.

Total Asset Turnover

A financial ratio that measures a company's efficiency in using its assets to generate revenue.

Total Assets

Total assets represent the sum of everything of value owned by a company, including tangible and intangible resources, which are reported on a company's balance sheet.