Oracle OCP 1Z0 053 Q677(Flashback Transaction Query)

677.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
Answer: ABD

supplemental log
supplemental log for the primary key
grant execute on dbms_flashback_query

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2076144/，如需轉載，請註明出處，否則將追究法律責任。