1Z0-908 Exam Question 36
Which two are true about binary logs used in asynchronous replication? (Choose two.)
1Z0-908 Exam Question 37
A valid raw backup of the shop.customers MyISAM table was taken.
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv='/var/tmp'
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)
You must restore the table. You begin with these steps:
1. Confirm that secure_file_priv='/var/tmp'
2. mysql> DROP TABLE shop.customers;
3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/
Which two actions are required to complete the restore? (Choose two.)
1Z0-908 Exam Question 38
Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?
1Z0-908 Exam Question 39
You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)
Which two groups of files will be backed up during a full backup? (Choose two.)
1Z0-908 Exam Question 40
Examine this command and output:

Which two statements are true? (Choose two.)

Which two statements are true? (Choose two.)
