Exhibit:

What does the possible_keys column in this output denote?

• A.whether there are any indexes in your query
• B.if it is possible for you to include any indexes in your query
• C.whether there are any indexes on the tables that you are querying
• D.if there are any indexes that may be used to solve this query

Comment: *

Name: *

Email: *

Verification: *

You have installed the validate_passwordplug-in and set the validate_password_policyvariable.
Which validation is affected by the validate_password_policy setting?

• A.whether a new password is rejected if it contains a word found in a dictionary file.
• B.whether a new password is rejected if it contains the current user's username.
• C.the amount of delay after an incorrect password is entered
• D.the length of time before a newly created password expires

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

You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

• A.binlog_format=STATEMENT
• B.log-bin
• C.apply-log
• D.bonlog_format=ROW
• E.gtid_enable

Comment: *

Name: *

Email: *

Verification: *

The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

• A.Change the table to use HASH indexes instead of BTREE indexes.
• B.Deactivate the query cache.
• C.Set the value of innodb_adaptive_hash_index to zero.
• D.Increase the size of the InnoDB buffer pool.
• E.Increase the value of the innodb_read_io_threads option.
• F.Increase the value of the innodb_lock_wait_timeout option.

Comment: *

Name: *

Email: *

Verification: *