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.