After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:What are the two most likely reasons for the slowness given this output? (Choose two.)
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? (Choose three.)
Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)
Consider these global status variables:Which two conclusions can be made from the output? (Choose two.)
You have just executed a manual backup by using this command: mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backupThe operation completed without error.What is the state of this backup and operation required before it is ready to be restored?
