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

question 2

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)A or C
• E)B or C

---

Definitions:

GPA

Grade Point Average, a standard way of measuring academic achievement in the U.S., usually on a scale from 0.0 to 4.0.

Variable Inputs

Inputs whose quantities can be changed in the short term to adjust production levels, such as labor and raw materials.

Fixed Input

An input whose quantity does not change with the level of output in the short run.