Choose two.
Examine this statement:
Mysql> DROP ROLE r_role1, r_role2; Which two are true?
AYou must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
BYou must revoke all privileges from r_role1 and r_role2 before dropping the roles.
CIt fails if at least one of the roles does not exist.
DExisting connections can continue to use the roles‘ privileges until they reconnect.
EIt fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
FIt fails if any of the roles is specified in the mandatory_roles variable.
相关试题
-
Choose two.Examine this statement:Mysql> DROP ROLE r_role1, r_role2; Which two are true?
-
Choose two.Examine this command, which executes successfully:Shell> mysqldump --master-data=2 --
-
elect * from table_lock_waits_summary_by_table where COUNT_STAR > 0 limit 1 \GWhich two are true?
-
Choose two.Which two statements are true about MySQL server multi-source replication?
-
Choose two.You have an installation of MySQL 8 on Oracle Linux.Which statement is true about disk te