Oracle
1Z0-062 · Question #111
1Z0-062 Question #111: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #111. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.