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:
The 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.