Oracle
1Z0-083 · Question #160
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…
The correct answer is A. It will return an error because creation of a local role is not allowed in CDB$ROOT. SQL> create role testrole container=current; create role testrole container=current ERROR at line 1: ORA-65049: Creation of local user or role is not allowed in this container.
Multitenant Architecture
Question
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: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; What is true?
Options
- 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 and APP1_ROOT.
- CROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
- DROLE1 will be created only in CDB$ROOT.
- EIt will return an error because common roles must start with C##.
How the community answered
(52 responses)- A83% (43)
- B2% (1)
- C4% (2)
- D10% (5)
- E2% (1)
Explanation
SQL> create role testrole container=current; create role testrole container=current ERROR at line 1: ORA-65049: Creation of local user or role is not allowed in this container.
Topics
#local roles#CONTAINER=CURRENT#CDB$ROOT restrictions#role creation
Community Discussion
No community discussion yet for this question.