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' ;
MODE
-------------
PROTECTING
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.
