多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题