Which two statements accurately describe a role? (Choose two.)
-
A role can be given to a maximum of 1000 users.
-
A user can have access to a maximum of 10 roles.
-
A role can have a maximum of 100 privileges contained in it.
-
Privileges are given to a role by using the CREATE ROLE statement.
-
A role is a named group of related privileges that can be granted to the user.
-
A user can have access to several roles, and several users can be assigned the same role.
To answer this question, you need to understand the concept of roles and their characteristics. Let's go through each option to understand why it is correct or incorrect:
Option A) A role can be given to a maximum of 1000 users. - This statement is not accurate. A role can be assigned to any number of users, so there is no maximum limit.
Option B) A user can have access to a maximum of 10 roles. - This statement is not accurate. A user can have access to any number of roles, so there is no maximum limit.
Option C) A role can have a maximum of 100 privileges contained in it. - This statement is not accurate. A role can contain any number of privileges, so there is no maximum limit.
Option D) Privileges are given to a role by using the CREATE ROLE statement. - This statement is accurate. Privileges can be assigned to a role using the CREATE ROLE statement in SQL.
Option E) A role is a named group of related privileges that can be granted to the user. - This statement is partially accurate. A role is indeed a named group of related privileges, but it is granted to the user, not the other way around.
Option F) A user can have access to several roles, and several users can be assigned the same role. - This statement is accurate. A user can have access to multiple roles, and multiple users can be assigned the same role.
The correct answers are Option D and Option F. These statements accurately describe a role.