Free 1z0-888 Exam Dumps

Question 11

MySQL is installed on a Linux server and has this configuration:
[mysqld] user=mysql
datadir=/data/mysql/
As the ‘root’ user, you change the datadir location by executing:
shell> cp –R /var/lib/mysql /data/mysql/ shell> chown –R mysql /data/mysql
What is the purpose of changing ownership of datadir to the ‘mysql’ user?

A. MySQL needs to be run as the root user, but files cannot be owned by it.
B. The mysqld process requires all permissions within datadir to be the same.
C. MySQL cannot be run as the root user.
D. MySQL requires correct file ownership while remaining secur

Correct Answer:A

Question 12

Examine the mysqldumpslow output:
1Z0-888 dumps exhibit
Which two options could explain the slow query?

A. There is network congestion between client and server.
B. No index has been defined on the filtered column.
C. There are 108 queries still being executed.
D. A table lock is causing delays.
E. A full table scan is being use

Correct Answer:AE

Question 13

Which are three facts about backups with mysqldump?

A. will lock all storage engines for duration of backup
B. can back up a remote database server
C. allow a consistent backup to be taken
D. are able to back up specific items within a database
E. create automatically compressed backups
F. are always faster to restore than binary backups

Correct Answer:BCD

Question 14

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. Set isolation level to be SERIALIZABLE.
B. Use the binary log row format.
C. Set isolation level to be READ COMMITTED.
D. Configure IPv6 network for hosts.
E. Guarantee a secondary index on every table.
F. Guarantee a primary key on every table.
G. Set multiple slave parallel worker thread

Correct Answer:ABF

Question 15

You are no longer able to log in to an existing MySQL Server because the root password credentials not
working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

A. Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
B. Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
C. Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.
D. Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
E. Start the MySQL Server with –initialize-insecure to force a password reset procedure on the command lin

Correct Answer:CD