Oracle Exam 1Z0-083 Topic 5 Question 106 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 106
Topic #: 5

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.

COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

AIt will return an error because creation of a local role is not allowed in CDB$ROOT.

BROLE1 will be created only in CDB$ROOT.

CIt will return an error because common roles must start with C##.

DROLE1 will be created only in CDB$ROOT and APP1_ROOT.

EROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

Show Suggested Answer

Suggested Answer: A

by Nickie at Sep 17, 2024, 10:54 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Nilsa

2 months ago

Haha, C## for common roles? What is this, SQL Server? I'm going with B, that's the most straightforward answer.

upvoted 0 times

...

Hui

2 months ago

I'm not sure, but I think Micaela is right. Creating the role in both CDB$ROOT and APP1_ROOT makes sense to me.

upvoted 0 times

...

Micaela

2 months ago

I disagree with Vonda. I believe the correct answer is D) ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

upvoted 0 times

...

Floyd

2 months ago

I'm not sure about this one. Is it possible that the role could be created in multiple containers since the question mentions APP1_ROOT and APP1_PDB1? I'm leaning towards E, but I'm not completely confident.

upvoted 0 times

...