Examine this statement: mysql> DROP ROLE r_role1, r_role2; Which two are true? (Choose two.)

Question

Options

• AIt fails if any of the roles is specified in the mandatory_roles variable.
• BYou must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
• CExisting connections can continue to use the roles' privileges until they reconnect.
• DYou must revoke all privileges from r_role1 and r_role2 before dropping the roles.
• EIt fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
• FIt fails if at least one of the roles does not exist.

• A
  3% (1)
• B
  10% (3)
• C
  74% (23)
• F
  13% (4)

Explanation

https://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_8026.htm

No community discussion yet for this question.