- oldguo-MySQL 8.0 OCP 原题解析-Q10
- MySQL 8 OCP(1Z0-908)认证考试题库原题（第12
- MySQL 8 OCP(1Z0-908)认证考试题库原题（第11
- MySQL 8 OCP(1Z0-908)认证考试题库原题（第10
- Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料
- Mysql 8.0 OCP认证考试原题题库整理-第6题（CUUG
- Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料
- Mysql 8.0 OCP认证考试原题题库整理-第4题（CUUG
- Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料
- Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料
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.
网友评论