Exam 1z0-083 topic 1 question 138 discussion

A correct

To specify the CONTAINER clause, you must be connected to a multitenant container database (CDB). To specify CONTAINER = ALL, the current container must be the root. To specify CONTAINER = CURRENT, the current container must be a pluggable database (PDB).

tested

ERROR at line 1: ORA-65049: Creation of local user or role is not allowed in this container

A correct test

SQL> alter system set common_user_prefix='' scope=spfile; System altered. SQL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 960495072 bytes Fixed Size 9141728 bytes Variable Size 306184192 bytes Database Buffers 637534208 bytes Redo Buffers 7634944 bytes Database mounted. Database opened. SQL> show parameter prefix NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ common_user_prefix string os_authent_prefix string ops$ private_temp_table_prefix string ORA$PTT_ SQL> SQL> SQL> create role role1 container=current; create role role1 container=current * ERROR at line 1: ORA-65049: Creation of local user or role is not allowed in this container SQL>

E Due to lack of C##

A 100% Tested in lab alter system set common_user_prefix = '' scope = spfile; start force; create role role1 container=current; ERROR at line 1: ORA-65049: Creation of local user or role is not allowed in this container.

Should be D If COMMON_USER_PREFIX is set to an empty string, Oracle will not enforce any restrictions on the names of common or local users, roles, and profiles. Setting this parameter to an empty string will result in no restrictions being placed on names of common and local users, roles, and profiles

Correct answer is A. You cannot execute create role statement with CONTAINER=CURRENT from CDB$ROOT CONTAINER Clause The CONTAINER clause applies when you are connected to a CDB. However, it is not necessary to specify the CONTAINER clause because its default values are the only allowed values. To create a common role, you must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root. To create a local role, you must be connected to a PDB. You can optionally specify CONTAINER = CURRENT, which is the default when you are connected to a PDB.

the command should work no as COMMON_USER_PREFIX is set set to empty string? So I think A is false

Agree, A is correct: 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.