Free 1z0-888 Exam Dumps

Question 16

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

Correct Answer:DE

Question 17

Which two statements are true about InnoDB auto-increment locking?

A. InnoDB never uses table_level locks.
B. InnoDB always protects auto-increment updates with a table-level lock
C. InnoDB does not use locks to enforce auto-increment uniqueness.
D. The auto-increment lock can be a table-level lock.
E. Some settings for innodb_autoinc_lock_mode can help reduce lockin

Correct Answer:DE

Question 18

Which three statements correctly describe MySQL InnoDBCluster?

A. The cluster can be operated in multimaster mode with conflict detection for DML statements.
B. All MySQL client programs and connectors can be used for executing queries.
C. It provides fully synchronous replication between the nodes.
D. There is support for automatic failover when one node fails.
E. The data is automatically shared between the nodes.
F. Each query will be executed in parallel across the node

Correct Answer:BDF