Which two options can be the next step?

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 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"



Leave a Reply 0

Your email address will not be published. Required fields are marked *