Which three options are most likely to be changed for production form their default values?

• A. max_connections
• B. max_user_connections
• C. innodb_buffer_pool_size
• D. innodb_log_file_size
• E. port
• F. join_buffer_size
• G. character_set_system

A crucial database, `db_prod', just disappeared from your production MySQL instance. In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;' Which three methods could have been used to prevent this SQL injection attack from happening?

• A. validating all user input before sending it to the database server
• B. removing any remaining anonymous accounts from your MySQL instance
• C. giving limited privileges to accounts used by application servers to interact with their backing databases
• D. writing your client code to properly escape all user input
• E. changing all passwords for the MySQL account `root'@'%' immediately after losing an employee who knew the current password
• F. using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions
• G. using a hashing or encryption method to secure all user passwords in your MySQL tables

Why should you be selective when granting the PROCESS privilege to an account?

• A. It allows a client to control running processes on a server.
• B. It allows a client to see another user's queries with the SHOW PROCESSLIST command.
• C. It allows a client to process scripts.
• D. It allows the use of stored routines.

Which two statements are true about InnoDB auto-increment locking?

• A. Some settings for innodb_autoinc_lock_mode can help reduce locking.
• B. InnoDB does not use locks to enforce auto-increment uniqueness.
• C. InnoDB never uses table_level locks.
• D. The auto-increment lock can be a table-level lock.
• E. InnoDB always protects auto-increment updates with a table-level lock

The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a / backuppartition available on NFS where backups are stored.
You investigate and gather this information:

Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?

• A. Take a backup, stop the server, remove the data files, and restore the backup:
  
• B. Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:
  
• C. Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:
  
• D. Execute OPTIMIZE TABLEso that the InnoDB engine frees unused pages on disk back to the file system: