1Z0-062 · Question #111
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…
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…
Question
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?
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 reports an error because the CONTAINER=ALL clause is not specified in the
- DIt fails and reports an error because the CONTAINER=CURRENT clause is not specified in the
- EIt executes successfully but neither tablespace nor the data file is created.
How the community answered
(34 responses)- A3% (1)
- B12% (4)
- C6% (2)
- E79% (27)
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
Community Discussion
No community discussion yet for this question.