A role, CON_RES, having all the privileges of the CONNECT and the RESOURCE database roles has to be created. As the first step, the CON_RES role is created like the CONNECT role.
Which two options can be the next step? (Choose two.)
A.
Grant the role CON_RES to CONNECT.
B.
Grant the role CON_RES to RESOURCE.
C.
Modify the role CON_RES to include the role RESOURCE.
D.
Modify the role CON_RES to include all the privileges of the role CONNECT to it.
E.
Modify the role CON_RES to include all the privileges of the role RESOURCE to it.
F.
Modify the role CON_RES to revoke those privileges that do not belong to either the CONNECT or the RESOURCE roles.
Explanation:
SQL > CREATE ROLE "CON_RES" NOT IDENTIFIED
grant connect to con_res;
E : modify the rol to include all privialge of resource
F : we have to create role con_res which is equal to connect + resource GRANT ALTER SESSION TO "CON_RES"
GRANT CREATE CLUSTER TO "CON_RES"
GRANT CREATE DATABASE LINK TO "CON_RES"
GRANT CREATE SEQUENCE TO "CON_RES"
GRANT CREATE SESSION TO "CON_RES"
GRANT CREATE SYNONYM TO "CON_RES"
GRANT CREATE TABLE TO "CON_RES"
GRANT CREATE VIEW TO "CON_RES"