Examine this list of MySQL data directory binary logs:binlog.000001binlog.000002.....binlog.000289binlog.000300binlog.000301binlog.indexNow examine this command, which executes successfully:mysqldump --delete-master-logs --all-databases > /backup/db_backup.sqlWhich two are true? (Choose two.)
Which step or set of steps can be used to rotate the error log?
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.)
You want to check the values of the sort_buffer_size session variables of all existing connections.Which performance_schema table can you query?
Examine these statements, which execute successfully:TRUNCATE test;BEGIN;INSERT INTO test(id, name) VALUES(1, “Hello”);ROLLBACK;SELECT id FROM test;Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)
Examine this command, which executes successfullmysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-backWhich statement is true about the copy-back process?
