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.)
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.
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
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
217972f
6 months, 2 weeks agoTrinhLK
10 months, 3 weeks agoxRodge
10 months, 3 weeks ago