Microsoft
98-364 · Question #63
Which of the following statements are correct regarding recovery of the InnoDB tables after a server crash? Each correct answer represents a complete solution. Choose all that apply.
The correct answer is B. They are automatically recovered at the server startup. D. The innodb_force_recovery option opens the InnoDB tables in the read-only mode. See the full explanation below for the reasoning.
Question
Which of the following statements are correct regarding recovery of the InnoDB tables after a server crash? Each correct answer represents a complete solution. Choose all that apply.
Options
- AThey can only be recovered from the dump files.
- BThey are automatically recovered at the server startup.
- CThey are recovered only after restarting the server with the innodb_force_recovery option
- DThe innodb_force_recovery option opens the InnoDB tables in the read-only mode.
How the community answered
(59 responses)- A14% (8)
- B81% (48)
- C5% (3)
Community Discussion
No community discussion yet for this question.