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:

Demand Curves

A graphical representation that shows the relationship between the price of a product and the quantity of the product that consumers are willing and able to purchase at various prices.

Marginal Utility

The extra value or satisfaction garnered by a consumer with the acquisition of one more unit of a good or service.

Total Utility

The overall satisfaction or happiness received from consuming a certain amount of goods or services.

Marginal Utility

The extra pleasure or benefit obtained from consuming an additional unit of a product or service.