Examine this command,which executes successfully: 

Mysqlbackup--user=dba-password--port=3306--with-timestamp--backup- 

dir=/export/backups backup-and-apply-log

A developer accidentally dropped the InnoDB table Customers from the 

Company database. 

There is a datadir copy from two days ago in the dbbackup directory. 

Which set of steps would restore only the missing table?

Examine the full path name of the backup image from MySQL Enterprise 

Backup with the--compress option: 

/backup/full/mybackup/myimage.img 

mysqlbackup.cnf contains this data: 

[mysqlbackup] 

backup-dir=/backup/full/myrestore 

backup-image=/backup/full/mybackup/myimage.img 

uncompress 

You must perform a database restore to a new machine. 

which command can provision the new database in datadir as 

/data/MEB?

Examine this command,which executes successfully: 

＄mysqlbackup --user=dba --password --port=3306-with-timestamp-only-know

file-types-backup-dir=/exprot/backups backup 

Which statement is true?

Your MySQL instance is capturing a huge amount of financial transactions every 

day in the finance database. Company policy is to create a backup every day. 

The main tables being updated are prefixed with transactions- 

These tables are archived into tables that are prefixed with archives-each month. 

mysqlbackup--optimistic-busy-tables="^finance\.transactions-.*"backup 

Which optimization process best describes what happens with the redo 

logs?

You issue this command:SHOW SLAVE STATUS\G 

In the output,there is a value for Seconds_behind_master. 

How is this time calculated?

Your MySQL environment has asynchronous position-based replication with 

one master and one slave. 

The slave instance had a disk I/O problem,so it was stopped. 

You determined that the slave relay log files were corrupted and unusable,but no 

other files are damaged. 

You restart MySQL Server. 

How can replication be restored?

What does the slave I/O thread do?

configuration file and CHANGE MASTER command are correct.Examine the GTID 

information from both master and slave（含图）

Which statement is true?

mysql＞SHOW GLOBAL VARIABLEG 

WHERE Variable_name m “tempdir” 

OR Variable_name m “tem_table_size”

（含图）

2 rown in set (0.01 nec) 

shell＞cd/var/lib/mysql 

shell＞1e-1丨grep temp 

Drwxr-x---,2 mysql mysql 4096 Dec 11 14:05 finnodb_temp 

Which statement is true about disk temporary tables for this installation?

Examine the command,which execute successfully: 

shell>mysqld --initialize-insecure 

Which statement is true?

Your my.cnf file contains these settings: 

[mysqld] 

log_output=FILE 

slow_query_log 

long_query_time=2.01 

log_queries_not_using_indexes 

You want to log queries that looked at a minimum of 5000 records and either 

took longer than 5 seconds to run or did not use indexes. 

Which contains all the settings that you need to add to or modify the slow log 

configuration?

You recently upgraded your MYSQL installation to MYSQL8.0. 

Examine this cdient error: 

Error 2059(HY000):authentication plugin'caching_sha2_password' 

cannot be Loaded:/usr/local/uysql/libplugin/caching_sha2_password.so:camnot 

open shared object file:No such or directory 

Which option will allow this client to connect to MYSQL Server?

parameters to suit your installation. 

Examine the output: 

#systemetl start mysqld 

Job for mysqld service failed becausa the control procesa exited with arror code. 

See “systemctl status mysqld,service"and "journalctl-xe" for details. 

#systemctl status mysqld.service 

mysqld.service-MySQt server 

Loaded: loaded(/usr/lib/systemd/system/myaqld;servica; enabled,;vendor 

preset:sisabled Active: failed(Result:exit-code)since Thu 2019-12-12 07:54:53 ACD; 

33s ago 

严禁复制Docs:man:mysqld(8) 

http://dev.mysql.com/doc/rofman/en/usingsystamd.html 

Process:2732 Exeetart/usr/sbin/mysqld SMYSQLD_OPTS (codoexitod, 

status=1/FAILURE) 

Pracess:2705 Execstartpre=/usr/bin/mysqld_pre_systemd (code exited, atatus- 

0/sUccess) 

Main PID:2732(code-exited，status=1/fAILURE) 

status:"Server startup in progress” 

DeC 12 07:54:49 oe17 systemd[1]:starting MySqL Servor... 

Dac 12 07:54:53 oe17 systemd[1]:mysqld,service: main process exited, 

code=exited,status=1/FAILURE 

Dac 12 07:54:53 oe17 systemd[1]: Failed to start MySQL server. 

Dac 12 07:54:53 oe17 systemd[1]: unit myeqld,service entered failed state. 

Dac 12 07:54:53 oe17 systemd[1]: mysqld,service failed 

What statement is true about the start attempt?

MySQL isinstaled on a linux server wit this coniguration: 

[mysqld] 

user=mysql 

datadir=/data/mysql 

Which method sets the default authentication to SHA-256 hashing for 

authenticating user account passwords?

How can mysqld_multi be configured to allow MySQL instances to use the 

same port number?

Examine these two reports taken 100 seconds apart: 

GLOBAL STATUS 1: 

Com_create_table = 500005 

Com_drop_table = 500003 

Com_flush=23 

Created_tmp_disx_tables=400000 

Created_tmp_tables=1200000 

Max_used_connections=92 

Open_files=50000 

Opened_files =5000 

Open_table_definitions = 3000 

Open_tables=1024O 

Opened_table_definitions=2869 

Opened_tables=3500000 

Threads_connected=62 

Threads_running=58 

Uptime = 100000 

GLOBAL STATUS 2: 

Com_create_table = 500505 

Com_drop_table=500498 

Com_flush=31 

Created_tmp_disk_tables=400400 

Created_tmp_tables=1201200 

Max_used_connections=92 

Open_filea=5000 

Opened_files=7505 

Open_table_definitions=3000 

Open_tables=1024 

Opened_table_definitions=2873 

Opened_tables = 3503500 

Threads_connected=67 

Threads_running=64 

Uptime=100100 

Your MySQL system normally supports 50-75 concurrent connections. 

Which configuration change will improve performance?

Examine this output: 

mysql>SHOW GLOBAL VARIABLES LIKE %dir

（含图）

You plan to add this parameter to the configuration: 

innodb_directories='/innodb_extras' 

Which statement is true?

MySQL programs look for option files in standard locations. 

Which method will show the option files and the order in which they are read?

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: 

...[System].../usr/sbin/mysqld(mysqld 8.0.18-conmereial)starting as process 2754 

...[System]...Starting upgrade of data directory. 

...[ERROR]...Table upgrade required.please do "REPAIR TABLE 'columns_priv'"or 

dump/reload to fix it! 

...[ERROR]...Table upgrade required.please do "REDAIR TABLE 'avant:"or 

dump/reload to fix it! 

...[ERROR]...Table upgrade required.Please do “REDAIR TABLE'proc*”or 

dump/reload to fix it! 

...[ERROR]...Table upgrade required.please do “REDAIR TABLE 'proxies_priv”or 

dump/reload to fix it! 

...[ERROR]...Table upgrade required.please do “REDAIR TABLE 'tables_priv`”or 

dump/reload to fix it! 

...[ERROR]...Failed to open mysql.event Table. 

严禁复制...[ERROR]...Failed to open mysql.proc Table. 

...[ERROR]...Failed topopulate DD tables 

...[System].../usr/sbin/mysqld:shutdown complete (mysqld 8.0.18- 

commercial)Mysql Enterprise 

server-Comnercial

Which step or set of steps will resolve the errors?