Oracle Database 12c: Installation and Administration — Question 6

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?

Answer options

• 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.

Correct answer: E

Explanation

The command fails to create the undo tablespace in the HR_PDB because the operation requires a specification of the CONTAINER clause to determine the target scope. Since neither the CONTAINER=CURRENT nor CONTAINER=ALL clause is provided, the database does not know where to apply the command, leading to the creation of neither the tablespace nor the data file.