Oracle
1Z0-888 · Question #40
1Z0-888 Question #40: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #40. The question stem and answer options stay visible for context.
Backup and Recovery
Question
A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?
Options
- Aa backup created with mysqldump --all-databases
- Ba backup created using FLUSH TABLES ... FOR EXPORT
- Can up-to-date replication slave
- Da file system-level snapshot
- Ea file system copy created while MySQL was shut down.
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 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.
Topics
#backup methods#table restoration#InnoDB recovery#online backups