Consider the index information for the dept_emp table in the employee's schema:

Which two conclusions can be made based on the output of the query? (Choose two.)

Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)

Consider these global status variables:

Which two conclusions can be made from the output? (Choose two.)

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackupcommand.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/,with extra instances having their own separate my.cnffile (for example /etc/mysql/instanceN.cnf) overriding the defaults.
A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?