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:

Frequency Marketing

A marketing strategy that rewards customers for frequent purchases or engagements with a brand, encouraging loyalty.

Usage Rate

The frequency at which a consumer uses a product or service, often influencing marketing strategies and segmentation.

Hotel Programs

Initiatives or loyalty schemes offered by hotels to reward frequent guests and enhance their staying experience.

Behavioral Segmentation

The method of segmenting a market into categories based on consumer awareness, perceptions, applications, or reactions towards a product.