A single InnoDB table has been dropped by accident.

Vendor: Oracle
Product: 1z0-888
Update on: Jul 26, 2025
Questions: 124

Oracle 1z0-888 Question Answer

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? (Choose two.)

a backup created with mysqldump --all-databases

a backup created using FLUSH TABLES … FOR EXPORT

an up-to-date replication slave

a file system-level snapshot

a file system copy created while MySQL was shut down.