Online Access Free 1Z0-888 Exam Questions

Which two are considered good security practices when using passwords? (Choose two.)

• A.Do not use dictionary-based words.
• B.Store passwords external to the database.
• C.Choose short passwords to save on storage space.
• D.Use one-way encryption for storage of passwords.
• E.Use simple keyboard actions that give mixed letters.

A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?

• A.redo log, doublewrite buffer, tablespace, and binary log
• B.redo log, binary log, doublewrite buffer, and tablespace
• C.binary log, redo log, doublewrite buffer, and tablespace
• D.doublewrite buffer, redo log, tablespace, and binary log

Consider:

Which statement best describes the meaning of the value for the key_len column?

• A.It shows how many columns in the index are examined.
• B.It shows how many bytes will be used from each index row.
• C.It shows the number of characters indexed in the key.
• D.It shows the total size of the index row.

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

• A.setting --skip-networking when remote connections are not required
• B.using SSL when transporting data over remote networks
• C.setting --mysql_secure_configuration to enable paranoid mode
• D.using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications
• E.setting specific grant privileges to limit remote authentication

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 --enable-cleartext-plugin -uroot -p -h dbhost.example.com
• B.export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
• C.SET GLOBAL mysql_cleartext_passwords=1;
• D.mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
• E.INSTALL PLUGIN mysql_cleartext_password SONAME `mysql_cleartext_password.so';