Oracle
1Z0-067 · Question #211
1Z0-067 Question #211: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #211. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.