Oracle
1Z0-063 · Question #222
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…
The correct answer is B. Database Point-in-Time Recovery D. Flashback Database. See the full explanation below for the reasoning.
Question
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?
Options
- ATable Point-in-Time Recovery
- BDatabase Point-in-Time Recovery
- CTablespace Point-in-Time Recovery
- DFlashback Database
- EFlashback Transaction Backout
How the community answered
(23 responses)- A9% (2)
- B70% (16)
- C4% (1)
- E17% (4)
Community Discussion
No community discussion yet for this question.