Oracle Database 12c: Advanced Administration — Question 114

In your database, the user SCOTT wants to retrieve the dropped HR. EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed?

Answer options

• A. Undo retention guarantee must be enabled.
• B. No other table with the same name should exist in the HR schema.
• C. SCOTT should have the FLASHBACK ANY TABLE privilege.
• D. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.
• E. No duplicates of the HR. EMPLOYEES table should exist in the recyclebin of the HR schema.
• F. The recycle bin should be enabled.

Correct answer: C, D, F

Explanation

The correct answer includes that SCOTT must possess the FLASHBACK ANY TABLE privilege (C), have the SELECT privilege on the HR schema and its recyclebin (D), and that the recycle bin must be enabled (F) for the FLASHBACK command to work. Options A, B, and E are not prerequisites for this command, as the undo retention guarantee, naming conflicts, and duplicate handling in the recyclebin do not affect the ability to recover the table.