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 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
正确答案:B
答案解析:有

微信扫一扫手机做题