Oracle Database Administration II — Question 134

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?

Answer options

• A. It will return an error because creation of a local role is not allowed in CDB$ROOT.
• B. ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
• C. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
• D. ROLE1 will be created only in CDB$ROOT.
• E. It will return an error because common roles must start with C##.

Correct answer: A

Explanation

The correct answer is A because local roles cannot be created in CDB$ROOT, which is a limitation in Oracle databases. The other options incorrectly state where the role would be created or the conditions under which it can be created, leading to misunderstandings about the role's scope and restrictions in container databases.