ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

117 / 155

Question 117:

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? 

Answer options:

A. Drop the tenpOi.dbf file, and then re-create the temp file.
B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.
C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
E. Create a new temporary tablespace and assign it as the default to the user.