1z0-078 Exam QuestionsBrowse all questions from this exam

1z0-078 Exam - 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.)

Show Answer
Correct Answer: BDE

For the successful execution of the command to create a pluggable database from another on a RAC database, several conditions must be met: The source PDB must be in READ ONLY mode on all CDB instances if the CDB is in No Archive mode to ensure data consistency. The command can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container, as this user has the necessary permissions to perform the operation. Lastly, Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set to handle file location configurations for the new PDB. The other options are either incorrect or not necessary for this specific operation.

Discussion

3 comments
Sign in to comment
xRodgeOptions: BDE
Mar 13, 2024

The given answer is incorrect. BDE is correct. A is incorrect, documentation states: "The source PDB cannot be closed." C is incorrect, as the TEMP tablespace does not matter to this operation F is incorrect, as it would be insane to require a production DB to be in restricted mode in order to clone it. From documentation: B: "If the CDB is not in ARCHIVELOG mode, then the source PDB must be in open read-only mode. This requirement does not apply if the CDB is in ARCHIVELOG mode." D: "The current user must have the CREATE PLUGGABLE DATABASE system privilege in both the root and the source PDB." E: "Either Oracle Managed Files is enabled, or the PDB_FILE_NAME_CONVERT initialization parameter is set." Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html

TrinhLKOptions: BDE
Mar 18, 2024

BDE is correct

217972fOptions: BDE
Jul 20, 2024

Sure of BDE