Oracle
1Z0-034 · Question #8
1Z0-034 Question #8: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #8. The question stem and answer options stay visible for context.
Question
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error: ERROR at line I: ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status What would be the most efficient way to rectify this error?
Options
- AAdd a new tempfile to the user's temporary tablespace and drop the tempfile that produced the
- BShut down the database instance, restore the temp01.tmp file from the backup, and then restart
- CAllow the database to continue running, drop the temp01.tmp temporary file, and then re-create it
- DTake the temporary tablespace offline, recover the missing tempfile by applying redo logs, and
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.