Question 10:
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true?
A) It fails if at least one of the roles does not exist.
B) You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
C) Existing connections can continue to use the roles' privileges until they reconnect.
D) You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
E) It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
F) It fails if any of the roles is specified in the mandatory_roles variable.
