1z1-908 Exam Question 31

Which step or set of steps can be used to rotate the error log?
  • 1z1-908 Exam Question 32

    You have a MySQL system with 500 GB of data that needs frequent backups.
    You use a mix of MyISAM and InnoDB storage engines for your data.
    Examine your backup requirement:
    * The MySQL system being backed up can never be unavailable or locked to the client applications.
    * The recovery from the backup must work on any system.
    * Only 1 hour of data can be lost on recovery of the backup.
    Which option fulfills all backup requirements?
  • 1z1-908 Exam Question 33

    Which four are types of information stored in the MySQL data dictionary? (Choose four.)
  • 1z1-908 Exam Question 34

    Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)
  • 1z1-908 Exam Question 35

    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.)