Oracle
1Z0-883 · Question #76
You have been notified that the apps' . reports' table has been accidentally truncated. You have single file mysqldump backup available taken prior to the truncate. The backup contains all the…
The correct answer is A. Restore the backup to another databases instance and obtain a copy of the reports table individually. See the full explanation below for the reasoning.
Question
You have been notified that the apps' . reports' table has been accidentally truncated. You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the apps' . reports' table must be restored without affecting the other remaining databases and tables. Which restore option is suitable in this scenario?
Options
- ARestore the backup to another databases instance and obtain a copy of the reports table individually.
- BExtract the
apps' .reports' table from the backup using the SOURCE command. - CExecute LOAD DATA INFILE
backup.sql' SCHEMA='apps' TABLE=reports' - DExecute mysqldump on the backup,sql file and apply ?filter arguments to obtain only the `apps' .
How the community answered
(24 responses)- A79% (19)
- B13% (3)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.