ExamQuestions.com

Register
Login
Upgrade to Oracle Database 12c Exam Questions

Oracle

Upgrade to Oracle Database 12c

63 / 125

Question 63:

You execute a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema. was enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege. RECYCLE_BIN - What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema? 

Answer options:

A. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.
B. Recover the table using traditional Tablespace Point In Time Recovery.
C. Recovery the table using Database Point In Time Recovery.
D. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.