Exam 1z0-083 topic 1 question 137 discussion

Actual exam question from Oracle's 1z0-083

Question #: 137
Topic #: 1

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

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.

Show Suggested Answer

Suggested Answer: BE 🗳️

by dunhill at May 9, 2021, 5:15 p.m.

Comments

Submit Cancel

RinD

Highly Voted 3 years, 8 months ago

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

upvoted 21 times

...

ObserverPL

Highly Voted 3 years, 7 months ago

Sorry guys, but B and D are CORRECT as I tested in practice couple of minutes ago: SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1 SERVICE_NAME_CONVERT=('my_new_service_1','my_new_service_3'); Pluggable database created. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB_PHRDB MOUNTED 4 PDB1 READ WRITE NO 5 PDB2 MOUNTED 6 PDB3 MOUNTED SQL> alter session set container=PDB3; SQL> exec DBMS_SERVICE.start_service('my_new_service_3'); BEGIN DBMS_SERVICE.start_service('my_new_service_3'); END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_SERVICE.START_SERVICE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored SQL> alter database open; Database altered. SQL> exec DBMS_SERVICE.start_service('my_new_service_3'); PL/SQL procedure successfully completed.

upvoted 5 times