Examine this statement: mysql> DROP ROLE r_role1, r_role2; Which two are true? (Choose two.)
A. It fails if any of the roles is specified in the mandatory_roles variable.
B. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
C. Existing connections can continue to use the roles’ privileges until they reconnect.
D. You must revoke all privileges from r_role1 and r_role2 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 at least one of the roles does not exist.
|
Download Printable PDF. VALID exam to help you PASS. |
 |