Oracle
1Z0-034 · Question #29
1Z0-034 Question #29: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.
Question
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform TSPITR andpreserve the object?
Options
- APerform Export before TSPITR and Import after TSPITR
- BMove objects to another schema that has the same tablespace assigned
- CPerform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
- DPerform Incomplete Recovery before TSPITR with the 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.