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


A

Business

You might also like to view...

Which of the following helps show connections between points?

A) Subordinate clauses B) Adjectives C) Transitions D) Direct approach

Business

Briefly explain how marketers use marketing controls

What will be an ideal response?

Business

When a bank reduces the depositor's checking account for service charges or check printing charges, the bank debits the depositor's account with the bank

Indicate whether the statement is true or false

Business

Which one of the following is influenced by the mode of transportation used by a company?

a. cost b. quality of raw materials purchased c. extent of government supervision d. compliance with ISO requirements

Business