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? (Choose three.)
A. SCOTT should have the SELECT privilege on the HR and its recyclebin.
B. No other table with the same name should exist in the HR schema.
C. The recycle bin should be enabled.
D. SCOTT should have the FLASCHBACK ANY TABLE privilege.
E. Undo retention guarantee must be enabled.
F. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
|
Download Printable PDF. VALID exam to help you PASS. |
 |