You are a Database Administrator of MySQL database.Few days back, your server crashed. Now, it is up and
online. You need to check the integrity of various tables used in the database. You need to issue the CHECK
TABLE command. For which of the following tables will this command work? Each correct answer represents a
complete solution. Choose two.
A.
FEDERATED
B.
MyISAM
C.
MERGE
D.
InnoDB
Explanation:
Answer D and BThe CHECK TABLE command works for the InnoDB and MyISAM tables. CHECK TABLE is a built-in tool
provided by MySQL for checking tables before any attempts to repair the database. It checks tables for
structural problems and ensures that no table data are corrupt. It is a SQL command that is used in conjunction
with the REPAIR TABLE and OPTIMIZE TABLE commands to check, repair, and optimize tables in a database
for optimal performance. It does not require that the database server be shut down. Instead, since this
command can only be sent to the server via a client, the server must be running throughout the process.
Answer C and A are incorrect. The CHECK TABLE command does not work for the MERGE and FEDERATED
tables.