Oracle Exam 1Z0-067 Topic 5 Question 20 Discussion

Actual exam question for Oracle's 1Z0-067 exam

Question #: 20
Topic #: 5

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 1:

ORA-01565: 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?

AAdd a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

BShut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

CAllow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.

DTake the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Show Suggested Answer

Suggested Answer: A

by Tarra at May 04, 2022, 02:05 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-067 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!