Q75. Examine this configuration:
1. CDB1 is a container database.
2. COMMON_USER_PREFIX is set to 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;
Which is true?
- 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##.
Answer: A