IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 17
What is the purpose of a role?
Answer options
- A. To define exactly what a specific user can and cannot do within a particular database once they have been authenticated
- B. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges
- C. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles
- D. To assign one or more users that need to run local DB2 applications and tools on a particular server to the DB2ADMNS or the DB2USERS group
Correct answer: A
Explanation
The correct answer is A because a role defines the specific permissions a user has within a database after they have been authenticated. Options B and C describe grouping users and privileges respectively, while D relates to user group assignments rather than the role's function.