Free 1Z0-063 Web TestEngine Demo

Q15 Multiple choice

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.)

Select all that apply.

A
Drop the tenp01.dbf file, and then re-create the temp file.
B
Add a new temp file to the temporary tablespace and drop the temp01.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.

1Z0-063 Web TestEngine demo