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?

Question

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?

Accepted Answer

B. restore all the data files from last Sunday's backup and then perform a time-based recovery

Answer

A. retrieve the table by using the flashback feature

Answer

C. restore all the data files from last Sunday's backup and then perform a log sequence recovery

Answer

D. restore all the data files from last Sunday's backup and then perform a cancel-based recovery

Answer

E. restore from last Sunday's backup only data files that belong to the tablespace in which the table

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…

Question

Options

How the community answered

Community Discussion