Oracle
1Z0-034 · Question #31
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…
The correct answer is C. Tablespace Point-in-Time Recovery (TSPITR). See the full explanation below for the reasoning.
Question
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?
Options
- AComplete Recovery with online redo log
- BComplete Recovery with archived redo log
- CTablespace Point-in-Time Recovery (TSPITR)
- DIncomplete Recovery with system change number (SCN)
How the community answered
(50 responses)- A12% (6)
- B2% (1)
- C78% (39)
- D8% (4)
Community Discussion
No community discussion yet for this question.