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.
RECYCLE_BIN was enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?
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
您在Oracle 11g release 1数据库上执行DROP USER CASCADE ,并立即意识到您忘记复制OCA。OCP模式的EXAM_RESULTS表。
RECYCLE_BIN在DROP用户执行之前已经启用,OCP用户已经被授予FLASHBACK ANY TABLE system特权。
恢复OCA内容的最快方法是什么?OCP模式的EXAM_RESULTS表?
A.执行闪回表OCA。重命名为OCP.EXAM_RESULTS;连接系统。
B.使用传统的表空间时间点恢复。
C.使用数据库时间点恢复表。
执行闪回表OCA。DROP RENAME TO EXAM_RESULTS;以OCP用户连接。
正确答案:D