Examine these statements and output:

Mysql> GRANT PROXY ON accounting@localhost TO ' '@'%' ; 

mysql> SELECT USER(), CURRENT_USER(), @@proxy_user;

（含图）

Which statement is true?

Examine this statement, which executes successfully:

（含图）

CREATE TABLE world.city(ID int NOT NULL AUTO INCREMENT,

Name char(35) NOT NULL DEFAULT ' ',

CountryCode char(3) NOT NULL DEFAULT ' ', District char(20) NOT NULL DEFAULT ' ',

Population int NOT NULL DEFAULT '0', PRIMARY KEY (ID.,

REY CountryCode(CountryCodE. )ENGINE=InnoDB;

You want to improve the performance of this query:

SELECT Name FROM world.city WHERE Population BETWEEN 1000000 AND 2000000;

Which change enables the query to succeed while accessing fewer rows?

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?

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.

Using Query Analyzer, where do you begin to look for problem queries?

使用查询分析器，从哪里开始查找问题查询?

Identify two ways to significantly improve data security.

确定两种显著提高数据安全性的方法

Which two statements are true about MySQL Enterprise Backup?

Examine these commands, which execute successfully on the ic1 host: mysqlsh> dba.createCluster( 'cluster1' , {memberWeight:35})

Mysqlsh> varmycluster = dba.getCluster ()

Mysqlsh> mycluster.addInstance ( 'ic@ic2' , {memberWeight:25})

Mysqlsh> mycluster.addInstance( 'ic@ic3' , {memberWeight:50})

Now examine this configuration setting, which is the same on all nodes:

Group_replication_consistency=BEFORE_ON_PRIMARY_FAILOVER

Which statement is true if primary node ic1 fails?

You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade. Examine the message sequence generated during the first start of MySQL 8.0.18:

Which step or set of steps will resolve the errors?

You plan to upgrade your MySQL 5.7 instance to version 8. You have installed the 8 build of MySQL Shell.

Examine this command executed from the operating system shell prompt:

Mysqlsh --uri root@localhost:3306 -- util check-for-server-upgrade

Which statement is true?

Database test contains a table named city that has the InnoDB storage engine. What is the content of the test folder in the data directory?

（含图）

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure?

InnoDB 集群创建过程中不包含哪两个 MySQL Shell 命令?

Which two authentication plugins require the plaintext client plugin for authentication to work?

哪两个身份验证插件需要明文客户端插件进行身份验证工作?

You are using mysqlcheck for server maintenance. Which two statements are true?

User account baduser@hostname on your MySQL instance has been compromised（泄露） . Which two commands stop any new connections using the compromised account?

哪两个命令阻止使用受感染帐户的任何新连接?