Oracle Database 12c: Advanced Administration — Question 147

Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/) PATH_PREFIX = '/disk2/oracle/pdb2';
Which two statements are true?

Answer options

• A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
• B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
• C. The tablespace specifications of pdb2 are the same as pdb1.
• D. All database objects belonging to common users in PD3I are cloned in PD32.
• E. pdb2 is created with its own private undo and temp tablespaces.

Correct answer: A, C

Explanation

Option A is correct because pdb2 is indeed created by cloning pdb1 and starts in mount state. Option C is also correct as the tablespaces for pdb2 mirror those of pdb1. The other options are incorrect for various reasons, such as incorrect file locations or misconceptions regarding user object replication.