What are the prerequisites for performing flashback transactions? (Choose all that apply)
A.
Supplemental log must be enabled
B.
Supplemental log must be enabled for the primary key
C.
Undo retention guarantee for the database must be configured
D.
“EXECUTE” permission on the DBMS_FLASHBACK package must be granted to the user
Explanation:
http://www.oracleflash.com/30/Oracle-11g-Flashback-Transaction-in-OEM-LogMiner-Interface.html
http://books.google.com/books?id=14ZH0eZV6G8C&pg=PA123&lpg=PA123&dq=flashback+transaction+prerequisite&source=bl&ots=brh9_V-4Wz&sig=4PvpL2uM1xTf2eKkpoKKmaI8RkY&hl=en&ei=ZSL8TKq0KIugsQOZ7ZT3DQ&sa=X&oi=book_result&ct=result&resnum=2&ved=0CB0Q6AEwAQ#v=onepage&q&f=false
