Role Information Deletion - Quiz Explanation

The correct answers are indicated below, along with text that explains the correct answers.
1. Which data dictionary view shows information about roles that have been assigned to other roles?
Please select the best answer.
  A. ROLE_ROLE_PRIVS
  B. ROLE_TAB_PRIVS
  C. ROLES_SYS_PRIVS
  D. USER_ROLE_PRIVS
  Answer A is correct. The ROLE_TAB_PRIVS shows the table privileges for a role, the ROLE_SYS_PRIVS shows the system privileges for a role, and the USER_ROLE_PRIVS show the privileges that a user has on a role.

2. Which of the following is not a repercussion of dropping a role?
Please select the best answer.
  A. The role is deleted from the database.
  B. Users lose privileges granted through this role.
  C. Privileges assigned to users through this role are assigned directly to the users.
  D. The role is deleted from list of available roles for users.
  Answer C is correct. Once a role is deleted, all privileges assigned to a user through that role are no longer available. If a privilege was assigned to the user through another role, or if the privilege was directly assigned to the user, it is not affected by dropping the role.

3. Which command will show the current roles for a user?
Please select the best answer.
  A. SELECT * FROM USER_TAB_PRIVS
  B. SELECT * FROM USER_ROLE_PRIVS
  C. SELECT * FRM DBA_ROLE_PRIVS
  D. SELECT * FROM SESSION_ROLES
  Answer D is correct. All of the other statements return information about privileges on roles and tables.