Question 31

Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?
  • Question 32

    You are using replication and the binary log files on your master server consume a lot of disk space.
    Which two steps should you perform to safely remove some of the older binary log files?
    (Choose two.)
  • Question 33

    Consider:

    What does the range value in the type column mean?
  • Question 34

    You have a server that has very limited memory but has a very large table.
    You will use mysqldumpto back up this table.
    Which option will ensure mysqldumpwill process a row at a time instead of buffering a set of rows?
  • Question 35

    A MySQL instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
    Which two will optimize the security of this setup? (Choose two.)