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.)
  • 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?
  • 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.)
  • 1Z0-908 Exam Question 40

    Examine this command and output:

    Which two statements are true? (Choose two.)