ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 136 discussion

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

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 Hide Answer
Suggested Answer: ABD 🗳️
by dunhill at May 9, 2021, 5:06 p.m.

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
Submit Cancel
RinD
Highly Voted 3 years, 6 months ago
ABE correct
upvoted 16 times
...
MSShaikh
Highly Voted 3 years, 5 months ago
Seems ABD is correct because GSMROOTUSER is only for CDB$ROOT
upvoted 9 times
ABAJ
3 years, 5 months ago
ABD is the correct answer
upvoted 5 times
...
...
7206e44
Most Recent 6 months, 3 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
7 months, 3 weeks ago
ABE, D is wrong because it has the same comun roles dont roles.
upvoted 1 times
...
antonica
7 months, 4 weeks ago
ABD correct
upvoted 1 times
...
dancymonkey
10 months, 1 week ago
ABE correct D It has the same number of roles as CDB1. > "not common roles?"
upvoted 1 times
...
_gio_
1 year, 4 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, 6 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
1 year, 10 months ago
ABD correct
upvoted 2 times
...
flaviogcmelo
2 years, 7 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, 7 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, 7 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, 7 months ago
agree with ABD . tested
upvoted 1 times
...
...
KLM
2 years, 8 months ago
I tested and correct are ABE
upvoted 1 times
...
antjvr
3 years, 2 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, 6 months ago
I think AEF
upvoted 1 times
dunhill
3 years, 6 months ago
RinD is right. I missed the keyword "roles". I thought it was "user".
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago