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

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?If a temp file belonging to a PDB temporary tablespace is lost or damaged, and the user issuing the statement uses it, an error during the execution of SQL statements that require that temporary space for sorting occurs. … The PDB can open with a missing temporary file. If any of the temporary files do not exist when the PDB is opened, they are automatically re-created. They are also automatically recreated at CDB startup.

Question:

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

Options:

The PDB is closed and the temp file is re-created automatically when the PDB is opened.

The PDB is closed and requires media recovery at the PDB level.

The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

The PDB does not close and starts by using the default temporary tablespace defined for the CD

Correct Answer

The Correct Answer for this Question is

The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.