1Z0-888 Exam Question 41
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 42
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 43
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?
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?
1Z0-888 Exam Question 44
After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
1Z0-888 Exam Question 45
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?