Exam 1z0-062 topic 1 question 130 discussion

Actual exam question from Oracle's 1z0-062

Question #: 130
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: E 🗳️
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.

by rdnkrkmz at Jan. 24, 2019, 12:54 p.m.

Comments

Submit Cancel

TuxBingo

4 years, 4 months ago

The correct answer is E (12.1), remember between 12.1 and 12.2, most of the important features are in 12.2

upvoted 1 times

...

rdnkrkmz

5 years, 10 months ago

For 12.2 release, A is correct answer. Because local_undo_enabled parameter allow to create local UNDO in PDB (tested 12.2)

upvoted 1 times

hggz

4 years, 9 months ago

Yes, A for 12.2, but E for 12.1

upvoted 2 times

...

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 1 question 130 discussion

Comments

TuxBingo

rdnkrkmz

hggz

SY0-701