Database Fundamentals — Question 156

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.)

Answer options

• A. FEDERATED
• B. MyISAM
• C. MERGE
• D. InnoDB

Correct answer: B, D

Explanation

The CHECK TABLE command is effective for MyISAM and InnoDB tables, making options B and D the correct answers. FEDERATED tables do not store data locally, and MERGE tables are just a representation of MyISAM tables, which do not support the CHECK TABLE command in the same way.