Oracle
1Z0-043 · Question #120
1Z0-043 Question #120: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #120. The question stem and answer options stay visible for context.
Question
You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? (Choose two)
Options
- ARestore the lost data file from the backup, and then flash back the database.
- BRestore the data file pertaining to index tablespace, and then recover the tablespace.
- CRestore all the data files, and then perform an incomplete recovery to get the tablespace back.
- DRestore all the data files, and then perform an incomplete recovery using the backup control file.
- EDrop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 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.