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

The correct answer is C. The PDB does not close and the temp file is re-created automatically whenever the container. 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…

New Features for Database Infrastructure and Architecture

Question

Options

AThe PDB is closed and the temp file is re-created automatically when the PDB is opened.
BThe PDB is closed and requires media recovery at the PDB level.
CThe PDB does not close and the temp file is re-created automatically whenever the container
DThe PDB does not close and starts by using the default temporary tablespace defined for the CD

How the community answered

(38 responses)

A
5% (2)
B
3% (1)
C
79% (30)
D
13% (5)

Explanation

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

Topics

#PDB temp file#temporary tablespace#automatic file recreation#CDB container

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice