---

Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night.  On Tuesday， client A drops a table at 8：00 a.m. as follows：  SQL> DROP TABLE cust_ord PURGE;  Table dropped.  Client B executes a query at 9：00 a.m. on the same table as follows：  SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *  ERROR at line 1：  ORA/x7f00942： table or view does not exist  Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）
A:retrieve the table by using the flashback feature
B:restore all the data files from last Sunday’s backup， and then perform a time­based recovery
C:restore all the data files from last Sunday’s backup， and then perform a log sequence recovery
D:restore all the data files from last Sunday’s backup， and then perform a cancel­based recovery
E:restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored， and then perform a complete recovery

---

出自：Oracle认证

显示答案