Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods for recovering the truncated table data?
A.
Table Point-in-Time RecoveryB. Database Point-in-Time Recovery
C.
Tablespace Point-in-Time Recovery
D.
Flashback Database
E.
Flashback Transaction Backout
Explanation:
Reference https://blogs.oracle.com/sql/how-to-recover-data-without-a-backup
Question 15
Which two best methods for recovering the truncated table data?
Answer is showing only one option.
advice
I would choose B,D