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.