Examine this command and output:Which two options will improve the security of the MySQL instance? (Choose two.)
You are using mysqlcheck for server maintenance.Which two statements are true? (Choose two.)
A MySQL server is monitored using MySQL Enterprise Monitor’s agentless installation.Which three features are available with this installation method? (Choose three.)
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?
A colleague complains about slow response time on your website.Examine this query and output:What is the most likely cause for the high number of lock waits?
Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.Which two sets of actions when completed will accomplish this? (Choose two.)
