Which of the Following Is True of Clustered Indexes

question 20

Multiple Choice

Which of the following is true of clustered indexes?

• A)They are normally slower than nonclustered indexes for retrieving data.
• B)Only one is allowed per table.
• C)They are normally slower than nonclustered indexes for updating data.
• D)They do not have data in the bottom level.
• E)A and C

---

Definitions:

Large-Sample Z

A statistical method used to approximate the significance of difference between means, applicable when sample size is large and variances are known or assumed to be equal.

Corresponding P-Value

The probability of obtaining a test statistic at least as extreme as the one that was actually observed, assuming that the null hypothesis is true.

Null Hypothesis

A hypothesis that suggests there is no statistical significance between the two variables being studied or no effect of a treatment.

Plus Four Estimate

A technique in estimating a binomial proportion and its confidence interval by adding four observations, two of which are successes and two are failures.