Oracle
1Z0-060 · Question #139
1Z0-060 Question #139: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #139. The question stem and answer options stay visible for context.
Question
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp. A user issues a query on a table on one of the PDBs and receives the following error: ERROR at line 1: ORA-01565: error in identifying file `/u01/app/oracle/oradata/CDB1/temp01.tmp' ORA-27037: unable to obtain file status Identify two ways to rectify the error.
Options
- AAdd a new temp file to the temporary tablespace and drop the temp file that that produced the error.
- BShut down the database instance, restore the temp01.tmp file from the backup, and then restart
- CTake the temporary tablespace offline, recover the missing temp file by applying redo logs, and then
- DShutdown the database instance, restore and recover the temp file from the backup, and then open
- EShut down the database instance and then restart the CDB and PDBs.
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.