1Z0-888 Exam Question 31
Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)
In which two situations should this command be used? (Choose two.)
1Z0-888 Exam Question 32
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)
Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)
1Z0-888 Exam Question 33
Consider these global status variables:

Which two conclusions can be made from the output?

Which two conclusions can be made from the output?
1Z0-888 Exam Question 34
You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?
Which statement describes the activation of that access for the user?
1Z0-888 Exam Question 35
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?
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail?