Exam 98-364 topic 1 question 167 discussion

Actual exam question from Microsoft's 98-364

Question #: 167
Topic #: 1

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

Show Suggested Answer

Suggested Answer: BD 🗳️

by rogeriosolano at June 28, 2022, 11:29 p.m.

Comments

Submit Cancel

rogeriosolano

2 years, 11 months ago

Selected Answer: BD

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.

upvoted 1 times

...