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 steps to accomplish the task.

Answer:

Explanation:
In order to accomplish the task, Rick will have to take the following steps:
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.