QUESTION 83
What is the order of tables shown in an EXPLAIN output?

QUESTION 84
You have a MySQL instance with the following variables in the /etc/my.cnffile:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

QUESTION 85
Examine the mydata table and SELECT statements:

You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?

QUESTION 86
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer?

QUESTION 87
Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

QUESTION 88
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

QUESTION 89
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?

QUESTION 90
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

QUESTION 91
Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

QUESTION 92
You have just created a replication slave from a backup of the master made with mysqldump:

You try to log in to the slave with the application user, but fail as follows:

The login works on the master.
Which two changes to the process can fix the issue?

QUESTION 93
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)

QUESTION 94
Which two statements are true regarding the creating of new MySQL physical and logical backups?

QUESTION 95
Which three allocate memory per thread in MySQL? (Choose three.)

QUESTION 96
Which two statements are true about InnoDB auto-increment locking? (Choose two.)

QUESTION 97
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?

QUESTION 98
A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

QUESTION 99
After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output? (Choose two.)

QUESTION 100
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)

QUESTION 101
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 mysqlclient to connect to the server and send clear text passwords?
(Choose two.)

QUESTION 102
You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to
“permissive”.
Examine this extract of the my.cnf file:

You issue this command to start MySQL Server:
systemctl start mysqld@replica
On which port is the server listening?

QUESTION 103
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?

QUESTION 104
Which three allocate memory per thread in MySQL?