Oracle Database Administration II — Question 113

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? (Choose two.)

Answer options

• A. PDB1 will be created in CDB2 and automatically opened.
• B. PDB1 will be created in CDB2 and left in MOUNT state.
• C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
• D. PDB1_C2_SRV will be created and started automatically.
• E. PDB1_C2_SRV will be created but not started.

Correct answer: B, E

Explanation

The correct answer is B and E because when a pluggable database is created from a remote link, it is typically left in a MOUNT state until further action is taken. Additionally, while the service PDB1_C2_SRV is created, it does not start automatically, which aligns with option E. Options A, C, and D are incorrect as they imply automatic opening or renaming, which do not occur in this scenario.