Your database operates in ARCHIVELOG mode. User-managed 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-00942： 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