Oracle
1Z0-873 · Question #77
1Z0-873 Question #77: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-873 to reveal the answer and full explanation for question #77. The question stem and answer options stay visible for context.
Question
The MySQL server host crashes at 10:00 in the morning, and is brought back online at 10:30. In order to ensure that all data are consistent, a copy is first made of the table, tablespace and log files currently on the server host, and these files are then restored from a backup made at 03:00 the same morning. What should be done in order to bring the database to the state it was at just before the server host crashed?
Options
- AThe mysql_restore utility should be used to update the server to its last known state.
- BThe binary logs recorded after the backup at 03:00 should be re-applied to make the database file
- CThe procedure described is wrong; instead, the mysqlcheck utility should be used and only if that
- DOnce the backup files from 03:00 have been restored, there is nothing more that can be done to
Unlock 1Z0-873 to see the answer
You've previewed enough free 1Z0-873 questions. Unlock 1Z0-873 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.