Your database operates in ARCHIVELOG mode. User/x7...
单选题

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?()

发布日期:2020-04-10

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

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定