Oracle Database 12c: Advanced Administration — Question 178

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

Answer options

• A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
• B. The PDB is closed and requires media recovery at the PDB level.
• C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
• D. The PDB does not close and starts by using the default temporary tablespace defined for the CD.

Correct answer: A

Explanation

Option A is correct because when a temporary file in a PDB is lost, the PDB will close, and upon reopening, the temp file will be automatically recreated. Options B, C, and D are incorrect as they imply different behaviors concerning PDB closure and recovery processes that do not align with how temporary files function in a pluggable database context.