Free 1z0-888 Exam Dumps

Question 6

You have created a new user with this statement:
CREATE USER ‘erika’@’localhost’ IDENTIFIED BY ‘first#1Pass’ PASSWORDEXPIRE; What is the outcome?

A. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.
B. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
C. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.
D. You receive a syntax error that indicates that you cannot set a password and expire it at the same tim

Correct Answer:A

Question 7

Exhibit:
1Z0-888 dumps exhibit
What does the possible_keys column in this output denote?

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

Correct Answer:A

Question 8

You enable binary logging on MySQL Server with the configuration: binlog-format=STATEMENT log-bin
Which database updates are logged on the master server to the binary log by default?

A. all updates except to the TEMPDB database
B. all updates except to the PERFORMANCE_SCHEMA database
C. all updates not involving temporary tables
D. all updates to the default database, except temporary tables
E. all updates to all databases

Correct Answer:D

Question 9

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

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

Correct Answer:AE

Question 10

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.
Which two are true about the login path feature?

A. mysql_config_editor is the only MySQL-provided utility that can print the values stored in.mylogin.cnf.
B. A .mylogin.cnf file can store at most one login path.
C. It provides a FIPS-compliant keyring for storing MySQL login details.
D. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
E. It is an alternative to storing the MySQL login details in a my.cnf file.
F. It provides means to help avoid accidentally exposing the MySQL login detail

Correct Answer:EF