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:

Research Hypothesis

A specific, testable prediction about the expected outcome of a study.

Probability

A measure of the likelihood that an event will occur, expressed as a number between 0 and 1.

Samples

Subsets of a population selected for measurement, observation, or questioning to make statistical inferences about the whole population.

Populations

In statistics, the entire pool from which a statistical sample is drawn and to which conclusions or inferences are made based on the sample.