Microsoft
98-364 · Question #43
98-364 Question #43: Real Exam Question with Answer & Explanation
Sign in or unlock 98-364 to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.
Question
You work as the Database Administrator for a MySQL database server. In an hour or so, you are able to bring a corrupted server online. You execute the CHECK TABLE command and find that some of the InnoDB tables need to be repaired. You restart the server and discover that auto-recover has failed. Which of the following steps will you take to recover the corrupted InnoDB tables?
Options
- ARun the ANALYZE TABLE command.
- BRun the REPAIR TABLE command.
- CRecover the tables from the last backup.
- DRun the OPTIMIZE TABLE command.
- ERestart the server with the innodb_force_recovery option.
Unlock 98-364 to see the answer
You've previewed enough free 98-364 questions. Unlock 98-364 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.