Oracle Database Administration II — Question 4

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

Answer options

• 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.

Correct answer: B, D, F

Explanation

Option B is correct because FLASHBACK drop indeed requires the RECYCLEBIN parameter to be set to ON for it to function. Option D is accurate as FLASHBACK DATA ARCHIVE does need undo to maintain all row versions in a tracked table. Option F is correct since FLASHBACK version query requires undo to obtain all versions of a row between specific times, whereas the other options either do not apply or are incorrect.