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 mysql client to connect to the server and send clear text passwords?

• 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: *

The MySQL instance is a default RPM installation on a Linux server.
Where are the errors written?

• A.in the /var/lib/mysql/hostname.log file
• B.no logging enabled by default
• C.in the /var/log/mysqld.err file
• D.in the syslog daemon on the server

Comment: *

Name: *

Email: *

Verification: *

Which three allocate memory per thread in MySQL?

• A.query cache
• B.thread cache
• C.read buffer
• D.internal temporary table
• E.sort buffer
• F.InnoDB buffer pool instance

Comment: *

Name: *

Email: *

Verification: *

You have a MySQL instance running in a single cpu (1vCPU) VM in a shared infrastructure environment.
Your users are complaining that MySQL is sporadically slow and you have a suspicion that the VM infrastructure host is at fault due to resource contention.
You review the output of your scripts that monitor the database VM operating system during an extended period of slowdown.
What are the two most common indicators of the VM infrastructure host being at fault due to resource contention? (Choose two.)

• A.90% RAM
• B.100% SWAP, 100% RAM
• C.10% CPU
• D.100% iowait
• E.100% CPU use, 50% RAM
• F.9.1 five minute load average, 10% iowait

Comment: *

Name: *

Email: *

Verification: *

Which two options describe how MySQL Server allocates memory?

• A.Each connection may have its own per-thread memory allocations.
• B.Each thread allocates memory from a global pool.
• C.Global memory resources are allocated at server startup.
• D.Thread memory is pre-allocated up to thread_cache_size for performance.

Comment: *

Name: *

Email: *

Verification: *