1Z0-078 practice question 7 of 15

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 PD3 must be closed on the CDS instance from where the command is executed. Correct answer

B: The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.

C: The source pdb must use a global temporary

D: It can be executed only by a common user with the create pluggable database system privilege connected to the root container. Correct answer

E: Oracle Managed Files must be enabled or PD3 file name convert must be set. Correct answer

F: All running CDB instances must be open in restricted mode.

Correct Answer:

A. The source PD3 must be closed on the CDS instance from where the command is executed.; 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 PD3 file name convert must be set.

Explanation

CREATE PLUGGABLE DATABASE … FROM performs a local clone.
1. Because no OPEN READ ONLY clause is specified, the source PDB (pdb1) must be closed in the instance that issues the command (A).
2. Only a common user connected to the root with the CREATE PLUGGABLE DATABASE privilege can run the statement (D).
3. Oracle must know where to place the cloned files; either Oracle Managed Files must be enabled or PDBFILENAMECONVERT supplied (E). Restricted mode for all instances or special temporary tablespaces are not required, and the read-only requirement in NOARCHIVELOG mode is irrelevant to this syntax.

Why Incorrect

B – Read-only source is required only when CDB is in ARCHIVELOG; statement does not mandate NOARCHIVELOG. C – No requirement exists that the source PDB use a global temporary tablespace. F – Instances need not be in restricted mode; normal open is acceptable.

References

1. Oracle Multitenant Admin Guide 19c, Sec. 3.3.1 “Cloning a PDB” – prerequisites list (source PDB closed unless using READ ONLY clause).

2. Ibid., Sec. 3.2 “About Creating a PDB” – requirement for common user with CREATE PLUGGABLE DATABASE.

3. Ibid., Example 3-8 – need for OMF or PDBFILENAMECONVERT when cloning in the same CDB.

Keep practicing

Take the free 1Z0-078 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test