Multiple choice technology databases

Your database operates in ARCHIVELOGmode. User-managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at8:00 a.m.as follows: SQL> DROP TABLEcust_ordPURGE; Table dropped. Client B executes a query at9:00 a.m.on the same table as follows: SQL> SELECT * FROMcust_ord SELECT * FROMcust_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?

  1. retrieve the table by using the flashback feature

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

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

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

  5. 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
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Since the table was dropped with the PURGE option, it bypasses the Recycle Bin, meaning flashback drop cannot be used. You must restore all data files from the last backup and perform a time-based incomplete recovery to a point just before 8:00 a.m.

Keep practicing — related questions