Security Roles   «Prev  Next»
l

 

Oracle Role Information Deletion - Quiz


Each question is worth one point. Select the best answer or answers for each question.

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

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.

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

Correct answers:

Your Score: 0