Exam 1z0-083 All QuestionsBrowse all questions from this exam
Go to Exam
Question 137

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

    Correct Answer: B, E

    PDB1 will be created in CDB2 and left in MOUNT state, as it requires further actions to be opened. Additionally, the service PDB1_C2_SRV will be created but not started automatically, as manual intervention is necessary to start the service. These align with standard behaviors observed when creating pluggable databases from database links.

Discussion
RinDOptions: BE

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

ObserverPLOptions: BD

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.

Aldrid

D Incorrect. D. PDB1_C2_SRV will be created and started automatically. It's not started automatically.. You start it manualy

gon20

but you have had to start the service, then the service existed but was closed. Then Option E is correct??

vkra

with your example it should be B and E (PDB1_C2_SRV will be created but not started.) not D (PDB1_C2_SRV will be created and started automatically.)

AldridOptions: BC

B, C C: https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13549

_gio_Options: BE

https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-133B6D33-3B52-433B-9C85-C4BEE4F7284E

DBA007Options: BD

B, D is Correct. Tested.

piontkOptions: BD

BD is the correct answer. Tested in lab.

ScottLOptions: BE

B E - see ObserverPL example

vkraOptions: BE

B and E, see example from ObserverPL

nobody347Options: AD

D 100% after created database sservice status can be checked through listener utilite lsnrctl status

dancymonkey

BD D - Tested lsnrctl status - serices already started

Neil107Options: BC

I believe it's B and C.

dunhillOptions: AD

I think AD