Oracle
1Z0-067 · Question #81
1Z0-067 Question #81: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #81. The question stem and answer options stay visible for context.
Question
A user issues a query on the sales table and receives the following error: ERROR at line 1: ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace?
Options
- ADrop the tenpOi.dbf file, and then re-create the temp file.
- BAdd a new temp file to the temporary tablespace and drop the tempOi.dbf file.
- CShut down the database instance, start up the database instance in mount state, create a new
- DTake the temporary tablespace offline, recover the missing temp file, and then bring the
- ECreate a new temporary tablespace and assign it as the default to the user.
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 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.