See the Exhibit to observe the roles assigned to the SL_REP user:
Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?
A.
The user must enable the role explicitly
B.
The user can grant the role to other users
C.
The user cannot user the role until the DBA enables it explicitly
D.
The user can start using the role immediately without any changes
Exhibit not showing
SELECT_CATALOG_ROLE
This role can be granted to users to allow SELECT privileges on data dictionary views.
With Admin option:
Only for system privileges, not object privileges.
SELECT_CATALOG_ROLE no default role assignment
SL_REP not explicitly granted, certainly not this role, A is right.
Without this role, nor the right to assign this role, B is wrong.
With SELECT_CATALOG_ROLE DBA role, with SL_REP user is irrelevant, C is wrong.
Only the roles defined as default are enabled.
When SL_REP needs to do some work that requires the privileges of the SELECT_CATALOG_ROLE role, he can issue a statement:
SET ROLE SELECT_CATALOG_ROLE;
or
dbms_session.set_role (‘SELECT_CATALOG_ROLE’);