Oracle
1Z0-063 · Question #232
1Z0-063 Question #232: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-063 to reveal the answer and full explanation for question #232. 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?
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.
Unlock 1Z0-063 to see the answer
You've previewed enough free 1Z0-063 questions. Unlock 1Z0-063 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.