Oracle
1Z0-067 · Question #211
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 A. The recycle bin should be enabled. C. SCOTT should have the SELECT privilege on the HR schema and its recyclebin. D. SCOTT should have the FLASHBACK ANY TABLE privilege. 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? (Choose three.)
Options
- AThe recycle bin should be enabled.
- BNo duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
- CSCOTT should have the SELECT privilege on the HR schema and its recyclebin.
- DSCOTT should have the FLASHBACK ANY TABLE privilege.
- ENo other table with the same name should exist in the HR schema.
- FUndo retention guarantee must be enabled.
How the community answered
(17 responses)- A76% (13)
- B12% (2)
- E6% (1)
- F6% (1)
Community Discussion
No community discussion yet for this question.