Virtual Labs

How does Role-Based Access Control (RBAC) simplify privilege management in databases?

a: By assigning permissions directly to every user individually. Explanation

Explanation

b: By grouping permissions into roles and assigning those roles to users. Explanation

Explanation

c: By allowing users to select their own permissions. Explanation

Explanation

d: By storing access rights in an external file system. Explanation

Explanation

What is a primary characteristic of a Discretionary Access Control (DAC) system?

a: Access rights are determined solely by strict system clearance labels. Explanation

Explanation

b: The owner of the data can grant and revoke access permissions to other users. Explanation

Explanation

c: Data permissions are permanently fixed and cannot be changed. Explanation

Explanation

d: Access is grouped exclusively by organizational job roles. Explanation

Explanation

Mandatory Access Control (MAC) is most likely to be required in which of the following environments?

a: A collaborative research lab where scientists freely share data. Explanation

Explanation

b: A small startup where developers need quick, unrestricted database access. Explanation

Explanation

c: A military or government system where strict, hierarchical security policies must be strictly enforced. Explanation

Explanation

d: A public blog where anyone can read articles. Explanation

Explanation

How are access rights updated in RBAC when a user changes departments?

a: The admin reassigns the user to a new role, updating permissions automatically. Explanation

Explanation

b: The user must request permissions one by one. Explanation

Explanation

c: All old permissions are retained permanently. Explanation

Explanation

d: The user must create a new account for the new role. Explanation

Explanation

What is a key advantage of RBAC for large organizations?

a: It provides scalable control by assigning permissions through roles. Explanation

Explanation

b: It allows employees to change their own permissions freely. Explanation

Explanation

c: It works without any administrative configuration. Explanation

Explanation

d: It automatically performs data encryption. Explanation

Explanation

What is a security risk of an incorrectly configured RBAC system?

a: Users may end up with more privileges than required. Explanation

Explanation

b: Database performance may slightly improve. Explanation

Explanation

c: All roles will automatically balance their permissions. Explanation

Explanation

d: Users will lose access to the system permanently. Explanation

Explanation

Access Control in Databases