Oracle
1Z0-052 · Question #240
In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #240. The question stem and answer options stay visible for context.
Managing Database Storage Structures
Question
In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?
Options
- Aflash back the database
- Bperform point-in-time recovery
- Cperform a full database recovery
- Ddrop and re-create the tablespace
- Euse Recovery Manager (RMAN) to recover the database
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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.
Topics
#tempfile#temporary tablespace#tablespace recovery#drop and recreate