QUESTION NO:  47 
Which two statements accurately describe a role? (Choose two.)
A. A role can be given to a maximum of  1000  users.
B. A user can have access to a maximum of  10  roles.
C. A role can have a maximum of  100  privileges contained in it.
D. Privileges are given to a role by using the CREATE ROLE statement.
E. A role is a named group of related privileges that can be granted to the user.
F. A user can have access to several roles, and several users can be assigned the same
role.

Answer: D, F
Explanation:
Privileges can be given to a role by using the CREATE ROLE statement. A user can have
access to several roles, and several users can be assigned the same role.

Incorrect Answers
A: There is no limitation to a  1000  users for one role in Oracle.
B: There is no limitation to a  10  roles for one user in Oracle.
C: There is no limitation to a  1000  privileges for one role in Oracle.
E: The role can act as a named group of privileges to execute certain tasks. But privileges can
be not related at all.

D. Privileges are given to a role by using the CREATE ROLE statement.