1Z0-888 Exam Question 11
How does the InnoDB storage engine handle deadlocks when they are detected?
1Z0-888 Exam Question 12
A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?
1Z0-888 Exam Question 13
Which two are considered good security practices when using passwords? (Choose two.)
1Z0-888 Exam Question 14
You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedirvalue) for your operating system.
Which step should you perform before defining your own databases and database tables?
Which step should you perform before defining your own databases and database tables?
1Z0-888 Exam Question 15
On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100,000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)
You decide to delete 100,000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)