Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command: What is the result?

The correct answer is E. It executes successfully but neither tablespace nor the data file is created. Interesting behavior in 12.1.0.1 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace. When the current container is a PDB, an attempt to create an undo…

New Features for Database Infrastructure and Architecture

Question

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:

What is the result?

Options

AIt executes successfully and creates an UNDO tablespace in HR_PDB.
BIt falls and reports an error because there can be only one undo tablespace in a CDB.
CIt fails and reportsan error because the CONTAINER=ALL clause is not specified in the command.
DIt fails and reportsan error because the CONTAINER=CURRENT clause is not specified in the command.
EIt executes successfully but neither tablespace nor the data file is created.

How the community answered

(20 responses)

A
10% (2)
C
15% (3)
D
5% (1)
E
70% (14)

Explanation

Interesting behavior in 12.1.0.1 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace. When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.

Topics

#PDB undo tablespace#CDB undo management#multitenant storage#shared undo

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice