1Z0-053單項選擇題每日一練(2019.03.21)

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?（）

A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. 
A LGWR Input/output （I/O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.  
1） Restore the corrupted redo log group.
2） Restore from a whole database backup. 
3） Perform incomplete recovery. 
4） Relocate by renaming the member of the damaged online redo log group to a new location. 
5） Open the database with the RESETLOGS option. 
6） Restart the database instance. 
7） Issue a checkpoint and clear the log.  
Identify the option with the correct sequential steps to accomplish the task efficiently（）.  

In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. 
Which method must you use to recover the lost data？（）