Which two are true regarding MySQL binary and text backups? A. Binary backups are usually faster than text backups. B. Binary backups are usually slower than text backups. C. Text backups are human-readable while binary backups are not. D. Binary…

While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use? A. Disconnecting idle localhost…

Which three data components are needed for point-in-time recovery? A. The error log B. The backup log C. The general query log D. Binary logs E. The data backup F. Configuration files

You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server’s binary log…

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a…

You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error: 130123 10:38:02 [ERROR] mysqld: unknown option ‘—ssl’ What is the cause of the error? A. The — ssl level was not…

You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor? A. All system users have access to the MySQL server via—login path local. B.…

Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why…

Which three methods will show the storage engine for the Country table? A. SHOW CREATE TABLE Country; B. SHOW ENGINE Country STATUS; C. SHOW TABLE STATUS LIKE ‘Country’; D. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= ‘Country’; E. SELECT ENGINE FROM…

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue? A. Table_open_cache B. Table_open_cache_instancs C. Table_definition_cache D. Tmp_table_size E. Max_heap_table_size F. Max_tmp_tables