nerdexam
Oracle

1Z0-083 · Question #159

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…

The correct answer is B. PDB1 will be created in CDB2 and left in MOUNT state. E. PDB1_C2_SRV will be created but not started. After you create the PDB, it is in mounted mode, and its status is NEW.

Manage Multitenant Container Databases

Question

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.)

Options

  • APDB1 will be created in CDB2 and automatically opened.
  • BPDB1 will be created in CDB2 and left in MOUNT state.
  • CPDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
  • DPDB1_C2_SRV will be created and started automatically.
  • EPDB1_C2_SRV will be created but not started.

How the community answered

(62 responses)
  • A
    5% (3)
  • B
    84% (52)
  • C
    10% (6)
  • D
    2% (1)

Explanation

After you create the PDB, it is in mounted mode, and its status is NEW.

Topics

#PDB cloning#database links#cross-CDB operations#service conversion

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice