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 but neither tablespace nor the data file is created.
B.
It fails and reports an error because the CONTAINER=CURRENT clause is not specified
in the command.
C.
It fails and reports an error because the CONTAINER=ALL clause is not specified in the
command.
D.
It executes successfully and creates an UNDO tablespace in HR_PDB.
E.
It falls and reports an error because there can be only one undo tablespace in a CDB.
A is correct answer.
SYS@pdb2_2:SQL> create undo tablespace undotbs01
2 datafile ‘/home/oracle/cdb2/pdb2_2/undotbs01.dbf’ size 2m
3 autoextend on
4 next 10m
5 maxsize unlimited;
Tablespace created.
SYS@pdb2_2:SQL> select file_name,tablespace_name from dba_data_files;
FILE_NAME
——————————————————————————–
TABLESPACE_NAME
——————————
/home/oracle/cdb2/pdb2_2/system01.dbf
SYSTEM
/home/oracle/cdb2/pdb2_2/sysaux01.dbf
SYSAUX
/home/oracle/cdb2/pdb2_2/userdata.dbf
USERDATA
SYS@pdb2_2:SQL> ! ls /home/oracle/cdb2/pdb2_2/undotbs01.dbf
ls: cannot access /home/oracle/cdb2/pdb2_2/undotbs01.dbf: No such file or directory
SYS@pdb2_2:SQL>
E this correct:
SQL> CREATE UNDO TABLESPACE undotb01 DATAFILE ‘/u01/app/oracle/db12cm/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;
Tablespace created.
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
——————————
SYSTEM
SYSAUX
TEMP
USERS
SQL> select name from dba_datafiles;
select name from dba_datafiles
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> show parameter undo
NAME TYPE VALUE
———————————— ———– ——————————
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> !ls -lrth /u01/app/oracle/db12cm/undotbs01.dbf
ls: cannot access /u01/app/oracle/db12cm/undotbs01.dbf: No such file or directory
No Errors/No Warnings, No datafiles, No tablespace
Alexis
You made a good test, but the answer is A, you proved in your example, the create undo tablespace is sucessful but doesn’t have datafile and tablespace.
Read the answer A again and you will understand.
Hello Jhon,
You’re right, it is the A. Thanks !!
Hi Jhon,
You’re right, it is the A. Thanks !!