63.Which method would you use to undo the changes made by a particular transaction without affecting
the changes made by other transactions?
A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and
use them for recovery
Answer: D
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12404577
闪回查询:查询在特定时间点存在的所有数据。
FLASHBACK_TRANSACTION_QUERY
displays information about all flashback transaction queries in the database. The database must have at least minimal supplemental logging enabled to avoid unpredictable behavior.