Oracle OCP 19c 认证1Z0-083考试(第4题)

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

• A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
• B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
• C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
• D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
• E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
• F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

 

 

A B F

 

F is definitely right. Reference: https://oracle-base.com/articles/10g/flashback-version-query-10g "Flashback version query is based on UNDO. As a result, the amount of time you can flashback is dep