Oracle Database 12c Advance Adminstration1z0-063 Test 2

Question : 31 of 40

Marks: +1, -0

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? (Choose two.)

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

Go to Question:

Prev Question

Next Question