Oracle Database Administration 2019 Certified Professional — Question 4

Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

Answer options

• A. The source PDB must be closed on the CDB instance from where the command is executed.
• B. The source PDB must be in READ ONLY mode on all CDB instances if the CDB is in No Archive mode.
• C. The source PDB must use a global temporary tablespace.
• D. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.
• E. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
• F. All running CDB instances must be open in restricted mode.

Correct answer: B, D, E

Explanation

Option B is correct because the source PDB must be in READ ONLY mode across all CDB instances if the CDB is not archiving. Option D is also necessary, as only a common user with the appropriate privilege can perform this action. Option E is required to ensure proper file management during the creation of the new PDB. The other options do not meet the necessary conditions for this command's successful execution.