Oracle
1Z0-883 · Question #76
1Z0-883 Question #76: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #76. The question stem and answer options stay visible for context.
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' .
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 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.