Solved

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

Correct Answer:

verifed

Verified

Related Questions

Q3: The MySQL delimiter that must be used

Q5: The MySQL keyword used to retrieve a

Q9: For use with this book,it is recommended

Q10: Which trigger type(s)does MySQL support?<br>A)BEFORE<br>B)AFTER<br>C)INSTEAD OF<br>D)A and

Q27: MySQL uses the MySQL LAST_INSERT_ID()function to provide

Q68: MySQL restores are run on the Restore

Q84: What is the MySQL Table Editor?

Q87: MySQL concurrency options include four transaction isolation

Q90: MySQL databases are backed up using the

Q91: Users log into MySQL Workbench using the