Oracle Database 12c: Advanced Administration — Question 16

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?

Answer options

• A. Table Point-in-Time Recovery
• B. Database Point-in-Time Recovery
• C. Tablespace Point-in-Time Recovery
• D. Flashback Database
• E. Flashback Transaction Backout

Correct answer: B, D

Explanation

The correct methods for recovering the truncated table data are Database Point-in-Time Recovery and Flashback Database. Database Point-in-Time Recovery allows you to restore the entire database to a specific point before the truncate operation, while Flashback Database lets you quickly revert the database to a previous state. The other options either do not target the specific need of recovering the truncated table or are not suitable given the scenario described.