Your database operates in ARCHIVELOG mode. Usermanaged 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： ORA00942： 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 featureB.restore all the data files from last Sunday’s backup， and then perform a timebased recoveryC.restore all the data files from last Sunday’s backup， and then perform a log sequence recoveryD.restore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryE.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

单项选择题

Your database operates in ARCHIVELOG mode. Usermanaged 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：
ORA00942： 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 timebased 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 cancelbased 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

1z0-043