代码改变世界

1Z0-053 争议题目解析686

2016-03-15 11:16  AlfredZhao  阅读(448)  评论(0编辑  收藏  举报

1Z0-053 争议题目解析686

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

题库中原题为:

686.You execute the following FLASHBACK TABLE command:

FLASHBACK TABLE emp TO TIMESTAMP TO_TIMESTAMP('2008-01-04 11:00:00', 'YYYY-MM-DD HH24:MI:SS');

Which two statements are correct?(Choose two.)
A.The EMP table that was dropped by mistake earlier is restored.
B.The FLASHBACK TABLE statement is executed as a single transaction.
C.The FLASHBACK TABLE statement does not maintain existing indexes on the EMP table.
D.The changes made to the EMP table since the specified time are undone if no constraint is violated
during flashback.
Answer:AD

争议点:
网上有人说选择BD,
比如:
LuiseDalian的解析:http://blog.itpub.net/17013648/viewspace-1346726/
Riveore的解析:http://blog.csdn.net/rlhua/article/details/17417859

首先A肯定不对,这里是闪回表到某一个时间点,并不是闪回drop。

初步结论:
题库答案错误,应该选择BD。