Oracle
1Z0-034 · Question #31
1Z0-034 Question #31: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
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)
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.