1Z0-053 争议题目解析684
考试科目:1Z0-053
题库版本:V13.02
题库中原题为:
684.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.
A.Restore the backup of all the data files.
B.Restore the backup of all the data files and the control file.
C.Restore the backup of only the data files that contain the dropped tables.
D.Restore the backup of all the data files belonging to the tablespace containing the dropped tables.
Answer:D
争议点:
网上有人说选择A,
比如:
LuiseDalian的解析:http://blog.itpub.net/17013648/viewspace-1346724/
做不完全恢复的一个必须条件就要把所有的数据文件恢复到需要做时间点恢复的之前的某个状态,然后所有的数据文件往前recovery,到一个时间点停下来,
才能够保证所有的数据文件都同步,这样子数据库才能够打开
比如:
Riveore的解析:http://blog.csdn.net/rlhua/article/details/17607785
戴总的题库此题也是A选项。
初步结论:
题库答案错误,应该选择A。