exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam

Exam 1z0-083 topic 1 question 137 discussion

Actual exam question from Oracle's 1z0-083
Question #: 137
Topic #: 1
[All 1z0-083 Questions]

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 Hide Answer
Suggested Answer: BE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
RinD
Highly Voted 3 years, 2 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, 2 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
vkra
1 year, 5 months ago
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.)
upvoted 2 times
...
gon20
3 years, 2 months ago
but you have had to start the service, then the service existed but was closed. Then Option E is correct??
upvoted 6 times
...
Aldrid
3 years, 2 months ago
D Incorrect. D. PDB1_C2_SRV will be created and started automatically. It's not started automatically.. You start it manualy
upvoted 6 times
...
...
piontk
Most Recent 10 months, 3 weeks ago
Selected Answer: BD
BD is the correct answer. Tested in lab.
upvoted 1 times
...
_gio_
1 year ago
Selected Answer: BE
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-133B6D33-3B52-433B-9C85-C4BEE4F7284E
upvoted 2 times
...
ScottL
1 year, 3 months ago
Selected Answer: BE
B E - see ObserverPL example
upvoted 1 times
...
vkra
1 year, 5 months ago
Selected Answer: BE
B and E, see example from ObserverPL
upvoted 1 times
...
DBA007
2 years, 6 months ago
B, D is Correct. Tested.
upvoted 2 times
...
nobody347
2 years, 10 months ago
D 100% after created database sservice status can be checked through listener utilite lsnrctl status
upvoted 1 times
dancymonkey
6 months, 1 week ago
BD D - Tested lsnrctl status - serices already started
upvoted 1 times
...
...
Neil107
2 years, 12 months ago
I believe it's B and C.
upvoted 1 times
...
Aldrid
3 years, 2 months ago
B, C C: https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13549
upvoted 4 times
...
dunhill
3 years, 2 months ago
I think AD
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago