Oracle
1Z0-063 · Question #232
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…
The correct answer is C. SCOTT should have the FLASHBACK ANY TABLE privilege. D. SCOTT should have the SELECT privilege on the HR schema and its recyclebin. F. The recycle bin should be enabled. See the full explanation below for the reasoning.
Question
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?
Options
- AUndo retention guarantee must be enabled.
- BNo other table with the same name should exist in the HR schema.
- CSCOTT should have the FLASHBACK ANY TABLE privilege.
- DSCOTT should have the SELECT privilege on the HR schema and its recyclebin.
- ENo duplicates of the HR. EMPLOYEES table should exist in the recyclebin of the HR schema.
- FThe recycle bin should be enabled.
How the community answered
(40 responses)- A18% (7)
- B5% (2)
- C70% (28)
- E8% (3)
Community Discussion
No community discussion yet for this question.