代码改变世界

1Z0-053 争议题目解析154

2016-03-11 14:54  AlfredZhao  阅读(713)  评论(0编辑  收藏  举报

1Z0-053 争议题目解析154

考试科目:1Z0-053
题库版本:V13.02

题库中原题为:

154.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives
the following error message:

Which is the recommended sequence of operations you need to perform for the query successfully?
A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and
then bring it online.
C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then
open the database with resetlogs.
D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover
the tablespace, and then put the database in normal operational mode.
Answer: C

争议点:
只是一个普通数据文件损坏,可以完全恢复,恢复完成后直接打开数据库就好,根本没必要使用resetlog选项打开数据库。
但是其他选项也不对。
B选项少一个recover的步骤。

初步结论:
既然其他选项也都不对,那就C吧。
但在我们实际工作过程中,记住千万不要这么做就好了。