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 `u01/o
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 tablespac
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.