Oracle
1Z0-034 · Question #16
1Z0-034 Question #16: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #16. The question stem and answer options stay visible for context.
Question
Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly. You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered. You decide to perform an incomplete recovery using the following command: SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00'; Identify the files that must be restored to recover the missing tables successfully.
Options
- ARestore the backup of all the data files.
- BRestore the backup of all the data files and the control file.
- CRestore the backup of only the data files that contain the dropped tables.
- DRestore the backup of all the data files belonging to the tablespace containing the dropped tables.
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 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.