Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 136 discussion

Actual exam question from Oracle's 1z0-083

Question #: 136
Topic #: 1

Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:

CREATE PLUGGABLE DATABASE pdb1 -
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT)
CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1';
Which three are true about PDB1? (Choose three.)

A. Service PDB1 is created for remote logins to PDB1.
B. It is in mount state after creation.
C. It has no local users.
D. It has the same number of roles as CDB1.
E. It has the same common users defined as does CDB1.
F. It has only local roles.

Show Suggested Answer

Suggested Answer: ABD 🗳️

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

Comments

Submit Cancel

RinD

Highly Voted 3 years, 9 months ago

ABE correct

upvoted 16 times

...

MSShaikh

Highly Voted 3 years, 8 months ago

Seems ABD is correct because GSMROOTUSER is only for CDB$ROOT

upvoted 9 times

ABAJ

3 years, 7 months ago

ABD is the correct answer

upvoted 5 times

...

7206e44

Most Recent 9 months, 2 weeks ago

Selected Answer: ABD

from freshly created PDB SQL> select count(*) from cdb_roles group by con_id; COUNT(*) ---------- 66 66 SQL> select count(*) from cdb_users where common='YES' group by con_id; COUNT(*) ---------- 25 24

upvoted 1 times

...

antonica

10 months, 2 weeks ago

ABE, D is wrong because it has the same comun roles dont roles.

upvoted 1 times

...

antonica

10 months, 2 weeks ago

ABD correct

upvoted 1 times

...

dancymonkey

1 year ago

ABE correct D It has the same number of roles as CDB1. > "not common roles?"

upvoted 1 times

...

_gio_

1 year, 7 months ago

Selected Answer: ABE

I think E is right because documentation says "common user is a database user that has the same identity in the root and in every existing and future PDB within this container." It's possible that the tests done in the lab are unreliable

upvoted 2 times

...

ScottL

1 year, 9 months ago

Selected Answer: ABD

ABD correct. See MSShaikh re GSMROOTUSER SYS@CDB1:CDB1> select con_id, count(1) from cdb_users where con_id in (1,5,11) and common='YES' group by con_id; CON_ID COUNT(1) ------ ----------- 1 26 11 25 5 25 3 rows selected. SYS@CDB1:CDB1> select con_id, count(1) from cdb_roles where con_id in (1,5,11) and common='YES' group by con_id; CON_ID COUNT(1) ------ ----------- 1 71 11 71 5 71

upvoted 1 times

...

hilaire

2 years ago

ABD correct

upvoted 2 times

...

flaviogcmelo

2 years, 9 months ago

Selected Answer: ABD

ABD. I created pdb3 with con_id=9. SQL> select con_id, count(1) from cdb_users where con_id in (1,9) and common='YES' group by con_id; CON_ID COUNT(1) ---------- ---------- 9 36 1 37 SQL> select con_id, count(1) from cdb_roles where con_id in (1,9) and common='YES' group by con_id; CON_ID COUNT(1) ---------- ---------- 9 89 1 89

upvoted 3 times

flaviogcmelo

2 years, 9 months ago

The number of roles are the sema even when the condition common='YES' is removed. SQL> select con_id, count(1) from cdb_roles where con_id in (1,9) group by con_id; CON_ID COUNT(1) ---------- ---------- 1 89 9 89 Ref.: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/overview-of-the-multitenant-architecture.html#GUID-3BB161DA-9CC0-4D61-A2C1-5D3662E0DECF https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/overview-of-the-multitenant-architecture.html#GUID-16473474-7F47-4E40-A592-01836E7D911C

upvoted 4 times

...

FeaRoX

2 years, 10 months ago

SQL> select count(*) from dba_users where common='YES'; COUNT(*) ---------- 36 SQL> alter session set container=CDB$ROOT; Session altered. SQL> select count(*) from dba_users where common='YES'; COUNT(*) ---------- 37 SQL> select count(*) from dba_roles; COUNT(*) ---------- 89 SQL> alter session set container=PDB1; Session altered. SQL> select count(*) from dba_roles; COUNT(*) ---------- 89 Seems like ABD

upvoted 2 times

freemun05

2 years, 10 months ago

agree with ABD . tested

upvoted 1 times

...

KLM

2 years, 11 months ago

I tested and correct are ABE

upvoted 1 times

...

antjvr

3 years, 5 months ago

You cant create local roles in CDB, only common, so always you will have the same number of roles when you create a pdb, all common roles that you have in CDB. ABD is the correct answer.

upvoted 5 times

...

dunhill

3 years, 9 months ago

I think AEF

upvoted 1 times

dunhill

3 years, 8 months ago

RinD is right. I missed the keyword "roles". I thought it was "user".

upvoted 2 times

...