Online Access Free 1Z1-888 Practice Test

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

• A.The name of the dictionary file is too obvious.
• B.The validate_password plug-in has not been loaded.
• C.The dictionary file word list is too short.
• D.validate_password_dictionary_file cannot be set without restarting the MySQL instance.
• E.validate_password_policy cannot be set without restarting the MySQL instance.
• F.The dictionary file is an insecure location.

Consider a replication setup where a snapshot of the replication status shows:

Which statement is true?

• A.The replication slave uses multisource replication with eight sources.
• B.The last event received from the sydney channel was at 2018-05-08 14:55:01.
• C.The sydney channel is keeping up with the received events.
• D.The melbourne channel is resolving a GTID conflict.
• E.The melbourne channel is keeping up with the received events.

old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

• A.All data in p1 and p3 partitions is removed and the table definition is changed.
• B.Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
• C.It results in a syntax error because you cannot specify more than one partition in the same statement.
• D.All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

• A.Configure IPv6 network for hosts.
• B.Set isolation level to be READ COMMITTED.
• C.Guarantee a primary key on every table.
• D.Set isolation level to be SERIALIZABLE.
• E.Guarantee a secondary index on every table.
• F.Set multiple slave parallel worker threads.
• G.Use the binary log row format.

You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; 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.You receive a syntax error that indicates that you cannot set a password and expire it at the same time.
• C.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.
• D.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.