Upgrade to Oracle Database 12c — Question 25

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.

Correct answer: D

Explanation

The correct answer is D because it allows the OCP user to recover the table directly from the RECYCLE_BIN and rename it appropriately in one step. Options A, B, and C are incorrect as they either involve the SYSTEM user, which is unnecessary, or use recovery methods that are not as direct or efficient as using FLASHBACK in this context.