Rick works as a database administrator for a MySQL server. The server uses the InnoDB storage engine. Rick
finds that a table’s performance is inconsistent. He wants to bring the table to a consistent state without
shutting down the server. Choose the required stepsto accomplish the task.

Answer:

Explanation:

Dump the table through mysqldump.
Drop the table.
Recreate the table through dump.
These steps will not require Rick to shut down the server and will put the table in a consistent state.