Oracle
1Z0-883 · Question #8
Which two are correct steps in taking a binary backup of MyISAM tables?
The correct answer is B. Stop the server or lock the tables prior to the backup. D. Make a copy of the .frm, .myd, and the .myi files. See the full explanation below for the reasoning.
Question
Which two are correct steps in taking a binary backup of MyISAM tables?
Options
- AAlways stop the server prior to the backup.
- BStop the server or lock the tables prior to the backup.
- CStop the server or lock the databases prior to the backup.
- DMake a copy of the .frm, .myd, and the .myi files.
- EMake a copy of the binary log and tablespace files.
How the community answered
(17 responses)- A6% (1)
- B76% (13)
- C12% (2)
- E6% (1)
Community Discussion
No community discussion yet for this question.