MySQL5.8-多选2

 Which two groups of files will be backed up during a full backup? (Choose two.) (您正在使用 mysqlbackup 备份原始 InnoDB 文件 在完整备份期间将备份哪两组文件)

Which two commands stop any new connections using the compromised account? (哪两个命令会阻止使用受损帐户的任何新连接)

Which three features are available with this installation method? (Choose three.) 使用 MySQL 企业监视器的无代理安装监视 MySQL 服务器 此安装方法提供哪三个功能

Mysql\>SELECT * FROM performance_Schema.table_10_waits_summary_by_table WHERE COUNT_STAAR \>0\G 

********************************2.row ************************************** 

OBJECT_TYPE:TABLE 

OBJECT_SCHEMA:test 

OBJECT_NAME:demo_test 

CONUNT_STAR:61567093

 SUM_TIMER_WAIT:59009007572922 

MIN_TIMER_WAIT:395922 

AVG_TIMER_WAIT:958095 

MAX_TIMER_WAIT:558852005358 

COUNT_READ:38665056 

SUM_TIMER_READ:20598719962188 

MIN_TIMER_READ:395922 

AVG_TIMER_READ:532728 

MAX_TIMER_READ:558852005358 

COUNT_WRITE:22902028 

SUM_TIMER_WRITE:38410287610743 

MIN_TIMER_WRITE:1130688 

AVG_TIMER_WRITE:1677006 

MAX_TIMER_WRITE:17205682920 

COUNT_FETCH:38665056 

SUM_TIMER_FETCH:20598719962188 

MIN_TIMER_FETCH:395922 

AVG_TIMER_FETCH:532728 

MAX_TIMER_FETCH:558852005358 

... 

COUNT_DELETE:22902028 

SUM_TIMER_DELETE:38410287610743 

MIN_TIMER_DELETE:1130688 

AVG_TIMER_DELETE:1677006 

MAX_TIMER_DELETE:17205682920

 Which two are true?

dba. rebootClusterFromCompleteOutage () 

Which two statements are true? (Choose two.) 

 you initialize the data directory with the mysqld --initialize command 

Which two will assist in locating the root password? 哪两个将有助于找到root密码

It will be a large, busy reporting data warehousing instance 它将是一个大型、繁忙的报告数据仓库实例

[mysqld] innodb_data_file_path= 

Which two configurations would satisfy long-term storage demands? 哪两种配置可以满足长期存储需求

This instance runs more than 100 transactions per second (此实例每秒运行超过 100 个事务)

You discover that some data was deleted at a particular point in time (您发现某些数据在特定时间点被删除)

You decide to perform a recovery from the binary logs as they are all available (您决定从二进制日志执行恢复，因为它们都可用)

Which two commands can restore the database to the point right before data was deleted? (哪两个命令可以将数据库还原到删除数据之前的位置)