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.
FLASHBACK TABLE ... TO BEFORE DROP Privileges for this statement are tied to the privileges for DROP. That is, any user who can drop an object can perform Flashback Drop to retrieve the dropped object from the recycle bin.
ref: https://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV89747
This section is not available anymore. Please use the main Exam Page.1z0-063 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
chitter
2 years, 11 months agobadguy001djh
4 years agoNorthKorean
5 years agobxmsta9ram
4 years, 11 months agoSugar
4 years, 10 months agotaiyang
4 years, 9 months ago