Multiple choice technology databases

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

  1. A role can be given to a maximum of 1000 users

  2. A user can have access to a maximum of 10 roles

  3. A role can have a maximum of 100 privileges contained in it.

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

  5. A role is a named group of related privileges that can be granted to the user

  6. A user can have access to several roles, and several users can be assigned the same role
Reveal answer Fill a bubble to check yourself
E,F Correct answer
Explanation

In database systems, a role is a named collection of privileges that can be granted to users (E is correct). Roles simplify permission management - many users can share the same role, and one user can have multiple roles (F is correct). Options A, B, C, and D mention arbitrary numeric limits that are not standard database concepts.

Keep practicing — related questions