1Z0-888 Exam Question 66
old_alter_tableis 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?
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?
1Z0-888 Exam Question 67
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.)
On the master server, the binary logs show:
What could explain this error? (Choose two.)
1Z0-888 Exam Question 68
Which statement describes how the relay log works?
1Z0-888 Exam Question 69
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)
1Z0-888 Exam Question 70
One of your colleagues is trying to make a change using the mysqlcommand-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?