Free 1Z0-034 Web TestEngine Demo

Q22 Single choice

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:

ERROR at line I: ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.

tmp' ORA-27037: unable to obtain file status What would be the most efficient way to rectify this error?

A
Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
B
Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
C
Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
D
Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

1Z0-034 Web TestEngine demo