Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料）-第4题
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_USERSWHERE USERHOST = 'fwuser@localhost' ;http://www.cuug.com.cn/uploadfile/2020-12/26306234458.jpgmysql> SELECT RULE FROM INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELISTWHERE USERHOST = 'fwuser@localhost';http://www.cuug.com.cn/uploadfile/2020-12/26306236485.jpgYou 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.
页:
[1]