Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)

• A.to find out why a query takes a long time to execute on a given table
• B.to make sure a table has no structural problems
• C.to improve performance by updating index distributing statistics on InnoDB tables
• D.to repair table structure problem
• E.to make sure that no table indexes are corrupted

Comment: *

Name: *

Email: *

Verification: *

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?

• A.--defaults-file=/etc/mysql/instance2.cnf
• B.--backup-instance=/var/lib/mysql/instance2
• C.--instance=/var/lib/mysql/instance2
• D.--copy-back-from-log
• E.--restore=2

Comment: *

Name: *

Email: *

Verification: *

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?
(Choose two.)

• A.mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
• B.INSTALL PLUGIN mysql_cleartext_password SONAME
  'mysql_cleartext_password.so';
• C.export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
• D.SET GLOBAL mysql_cleartext_passwords=1;
• E.mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com

Comment: *

Name: *

Email: *

Verification: *

You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-typeis set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)

• A.The server needs more cores to use all slave threads.
• B.The salve has two intermediate relay slaves connected to it.
• C.THREAD_ID 21has stopped running.
• D.At most, two schemas are being updates concurrently.
• E.The slave is configured with slave_parallel_workers= 4
• F.The slave cannot process the relay log fast enough to use all threads.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding MySQL security? (Choose two.)

• A.The mysqld process should be run as root or administrator.
• B.The mysqld process owner should own all files and directories to which the server writes.
• C.The root or administrator users should own all files and directories to which the server writes.
• D.The mysqld process should not be run as root or administrator.
• E.The mysql user needs to have sudo privileges.

Comment: *

Name: *

Email: *

Verification: *