1Z0-908 Exam Question 61
Examine this query and output:

Which two statements are true? (Choose two.)

Which two statements are true? (Choose two.)
1Z0-908 Exam Question 62
Your my.cnf file contains these settings:

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?
1Z0-908 Exam Question 63
You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
Which is the best way to encrypt the file?
1Z0-908 Exam Question 64
Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)
1Z0-908 Exam Question 65
Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?
