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?
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.
Explanation:
BCF
check out this;
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9012.htm#SQLRF01802
correct answer should be C,D,& F.