Which two statements are true about MySQL Enterprise Backup?

Which two statements are true about MySQL server multi-source replication?

You issue this command:

SHOW SLA VE STA TUS

In the output, there is a value for seconds_behind_master.

How is this time calculated?

mysql> SHOW SLAVE STATUS\G

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Seconds_Behind_Master: 1612

Seconds_Behind_Master value is steadily growing.

What are two possible causes?

Examine the command, which executes successfully:

shell> mysqld --initialize

Which statement is true?

Which two are true about differences between logical and physical upgrades of MySQL

databases?

You have a MySQL client installed on your Linux workstation with a default installation. You

have your admin login credentials to connect to a MySQL server running Microsoft Windows

on remote host 192.0.2.1:3306 to connect to the world database.

Which four options need to be specified to complete this task with a single command?

A) --port=3306

B) --protocol=pipe

C) --host=192.0.2.1

D) --protocol=UDP

E) --user=admin

F)

G)

H)

I) --database=world

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?