OCP-V13-686

1. You execute the following FLASHBACK TABLE command:

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.

在闪回期间如果没有约束限制。改变会用到EMP表上到指定的时间被撤销

Answer:AD

答案解析：
排除法：A错，C错，D正确
A，应该使用FLASHBACK TABLE … TO BEFORE DROP来恢复，利用回收站原理。A错
C选项是错的！ .Flashback Table restores tables while automatically maintaining associated attributes such
as current indexes