Which two statements accurately describe a role? (Choose two.)

The correct answer is 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. E: A role is a named group of Privileges that can be granted to a user. F: 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…

Controlling User Access

Question

Options

AA role can be given to a maximum of 1000 users.
BA user can have access to a maximum of 10 roles.
CA role can have a maximum of 100 privileges contained in it.
DPrivileges are given to a role by using the CREATE ROLE statement.
EA role is a named group of related privileges that can be granted to the user.
FA user can have access to several roles, and several users can be assigned the same role.

How the community answered

(21 responses)

A
5% (1)
C
5% (1)
D
14% (3)
E
76% (16)

Explanation

E: A role is a named group of Privileges that can be granted to a user. F: 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. D: Privileges can be given to a role by using a CREATE ROLE Statement is incorrect. Privileges are given to a role by the use of a GRANT statement.

Topics

#roles#role characteristics#privilege assignment#user-role relationship

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice