1Z0-888 Practice Online

Question 1

You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

A : ---old-passwords, to start MySQL to use the old password format while running without the grant tables.

B : ---reset-grant-tables, to start the server with only the mysql database accessible.

C : ---read-only, to set all data to read-only except for super users

D : ---skip-networking, to prohibit access from remote locations

Answer: D

Question 2

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE '/etc/passwd' INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?

A : executing REVOKE LOAD FROM *.*

B : setting the --local-service=0 option when starting mysqld

C : executing REVOKE FILE FROM *.*

D : executing REVOKE FILE ON *.* FROM ' ' @'%'

E : setting the --local-infile=0 option when starting mysqld

F : setting the --open-files-limit=0 option when starting mysqld

Answer: A

Question 3

This output is from a SHOW SLAVE STATUS:

Other-Image-21012ebcf-4af1-4a8c-8698-593bba89e0f8

What would cause the SQL_Delay variable to have a value of 360?

A : The master has performed a large transaction, which will take 360 seconds to complete on the slave

B : The network latency between the master and the slave is 360 milliseconds.

C : The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

D : The slave was configured for delayed replication with a delay of six minutes.

Answer: D

Question 4

One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail

A : max_connections requires the GLOBAL scope.

B : Its current user does not have the SUPER privilege.

C : max_connections is not a dynamic variable. You need to change the config file and restart the database.

D : Users can control only the max_user_connections variable.

Answer: A

Question 5

Consider:

Other-Image-27e18e2aa-4a53-4473-9634-03ec3a7131fa

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

A : It shows how many bytes will be used from each index row.

B : It shows the number of characters indexed in the key.

C : It shows the total size of the index row.

D : It shows how many columns in the index are examined.

Answer: A

Name:	MySQL 5.7 Database Administrator
Exam Code:	1Z0-888
Certification:	Oracle MySQL
Vendor:	Oracle
Total Questions:	125
Last Updated:	Apr 24, 2024

Download Demo 1Z0-888 Dumps

Create Account

Password Recovery

1Z0-888 Practice Online

Download Demo 1Z0-888 Dumps

Member Login

Create Account

Password Recovery

1Z0-888 Practice Online