MySQL 8.0 OCP认证考试原题题库整理（CUUG内部资料）-第4题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询MySQL 8.0 OCP认证考试原题题库整理（CUUG内部资料）-第4题
4、Choose two.
User `fwuser`@`localhost` is registered with the MySQL Enterprise Firewall and has been granted privileges for the SAKILA database.
Examine these commands that you executed and the results:
MySQL> SELECT MODE FROM INFORMATION_SCHEMA.MYSQL_FIREWALL_USERS
WHERE USERHOST = 'fwuser@localhost' ;
MySQL> SELECT RULE FROM INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST
WHERE USERHOST = 'fwuser@localhost';
You then execute this command:
MySQL> CALL MySQL.sp_set_firewall_mode('fwuser@localhost' , 'RESET') ;
Which two are true?
A) The fwuser@localhost account is removed from the MySQL.user table.
B) The information_schema.MYSQL_FIREWALL_WHITELIST table is truncated.
C) The whitelist of the fwuser@localhost account is truncated.
D) The MySQL.firewall_users table is truncated.
E) The firewall resets all options to default values.
F) The fwuser@localhost account mode is set to DETECTING.
G) The fwuser@localhost account mode is set to OFF.
