Oracle
1Z0-043 · Question #47
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?
The correct answer is D. Do not perform a recovery, but create a new temporary tablespace, make it the default temporary. See the full explanation below for the reasoning.
Question
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?
Options
- Aflash back the database
- Bimport the temporary tablespace from the last export
- Crestore all the data files and temporary files from the last full database backup and perform a recovery
- DDo not perform a recovery, but create a new temporary tablespace, make it the default temporary
How the community answered
(56 responses)- A14% (8)
- B4% (2)
- C5% (3)
- D77% (43)
Community Discussion
No community discussion yet for this question.