1Z0-083 practice question 30 of 35

Choose two. Examine this configuration: 1. CDB1 and CDB2 are two container databases. 2. PDB1 is a pluggable database in CDB1. 3. PDB1_C1_SRV is a…

Full set: 286 questions
Choose two. Examine this configuration: 1. CDB1 and CDB2 are two container databases. 2. PDB1 is a pluggable database in CDB1. 3. PDB1_C1_SRV is a service for PDB1. 4. CDB1_LINK is a database link in CDB2 referring to PDB1. 5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service. You execute these commands successfully: $ sqlplus sys/oracle_4U@cdb2 as sysdba SQL> CREATE PLUGGABLE DATABASE PDB1 FROM PDB1@CDB1_LINK SERVICE_NAME_CONVERT= ('PDB1_C1_SRV', 'PDB1_C2_SRV') ; Which two are true?
Answer options
A: PDB1_C2_SRV will be created but not started. Correct answer
B: PDB1 will be created in CDB2 and automatically opened.
C: PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
D: PDB1 will be created in CDB2 and left in MOUNT state. Correct answer
E: PDB1_C2_SRV will be created and started automatically.
Correct Answer:
A. PDB1_C2_SRV will be created but not started.; D. PDB1 will be created in CDB2 and left in MOUNT state.
Explanation

CREATE PLUGGABLE DATABASE … FROM dblink without an OPEN clause leaves the new PDB in MOUNT state.
SERVICENAMECONVERT creates replacement services in the cloned PDB, but services are started only when the PDB is opened. Therefore, in CDB2 a new PDB1 is created and mounted, and its service PDB1C2SRV exists but is not yet started.

Why Incorrect

B – Without OPEN {READ WRITE}, the new PDB is not opened automatically. C – The source service in CDB1 is unchanged; a new service is created in CDB2. E – A mounted PDB cannot start its services automatically.

References

1. Oracle® Database 19c SQL Language Reference, “CREATE PLUGGABLE DATABASE”, description of OPEN clause.

2. Oracle® Multitenant Guide 19c, Sec. 3.3.5 “SERVICENAMECONVERT”, note on service state after clone.

Scroll to Top