Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the
HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE u01/oracle/rddb1/undotbs01.dbf` SIZE 60M AUTOEXTEND ON;
What is the result?
A.
It executes successfully and creates an UNDO tablespace in HR_PDB.
B.
It falls and reports an error because there can be only one undo tablespace in a CDB.
C.
It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
D.
It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
E.
It executes successfully but neither tablespace nor the data file is created.
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.
For E to be correct, answer shoud be “It fails but…” Bad proposed question, I’m sure it is different in the real exam.
You’re right:
“When the current container is a PDB, an attempt to create an undo tablespace FAILS without returning an error.”
https://docs.oracle.com/database/121/ADMIN/cdb_admin.htm