请选择 进入手机版 | 继续访问电脑版

北京oracle培训_oracle培训哪家好_CUUG官方论坛_CUUG培训怎么样_CUUG官网

 找回密码
 立即注册
查看: 5503|回复: 0

Mysql 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第4题

[复制链接]
发表于 2021-2-20 10:30:14 | 显示全部楼层 |阅读模式
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.
未标题4.jpg

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|CUUG认证培训 ( 京ICP备11008061号 )

GMT+8, 2024-3-29 13:32 , Processed in 0.021611 second(s), 18 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表