To Create a MySQL Index Using SQL,the Correct SQL Statement

question 21

Multiple Choice

To create a MySQL index using SQL,the correct SQL statement is ________.

• A)ALTER TABLE {TableName} ADD INDEX {IndexName}
• B)ALTER TABLE {TableName} INSERT INDEX {IndexName}
• C)CREATE INDEX {IndexName} ON TABLE {TableName}
• D)Both A and C are correct

---

Definitions:

Standard Deviation

A statistic that indicates the dispersion or variability of a set of numerical data points around the mean.

Sample Size

The number of observations or participants included in a statistical sample.

Mean Value

The average of a set of numbers, calculated by dividing the sum of all the numbers by the count of the numbers.

Mode

The mode, or the value with the highest frequency, in a set of numbers.