MySQL 5.6 Database Administrator 試験
Question No : 1
You are investigating the performance of a slave and see the following in the Performance Schema on the slave:
On the master, you have:
Which two statements are true based on the information given?
Question No : 2
You create a login-path by using mysql config editor on a Linux operating system as the user ‘sean’.
[[email protected] --]$ mysql_config_editor set --login-path=seanfedora --host=localhost Cuser=sean Cpassword
Which two statements are true about the command that you have executed?
Question No : 3
You install a copy of MySQL 5.6.13 on a brand new Linux server by using the RPM packages.
The server starts successfully as verified by the following commands:
You attempt to log in as the root user with the following command:
$mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost’ (using password: NO)
Which statement is true about this scenario?
Question No : 4
Which two INFORMATION SCHEMA tables contain information about the execution state of connections in the MySQL Server?
Question No : 5
Review the definition of the phone_list view.
The tables employees and employee_phone are InnoDB tables; all columns are used In this view.
The contents of the phone_list view are as follows:
Which method can you use to change the cell_no value to ‘555-8888’ for John Doe?
Question No : 6
You enable the Slow Query Log. You want to log only those queries that perform full table scans or take longer than 0.5 seconds to complete.
Which two options should be used with the Slow Query Log?
Question No : 7
Which two methods can be used to Install a MySQL server as a Windows service?
Question No : 8
You occasionally have blocking transactions on your system. You want to create a query that will return the thread ID of Connections that are running for longer than 30 seconds and are blocking at least one other connection.
Which two INFORMATION_SCHEMA_tables, when joined, will provide this information?
Question No : 9
You are installing a MySQL server on a fresh installation of lJnux by using the MySQL Enterprise RPM packages.
Which three actions are performed during installation?
Question No : 10
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?
Question No : 11
Consider a total and Sustained failure of the disk on which the MySQL data directory resides.
Which three High Availability scenarios are resilient to this case?
Question No : 12
Considtr the MySQL Enterprise Audit plugin.
You add the following lines to the mycnf configuration file:
You attempt to start up the MySQL service and notice that it fails to start.
Which two statements would explain why the service did not start?
Question No : 13
Which three are key advantages of standard MySQL replication?
Question No : 14
You have a login-path named “adamlocal” that was created by using the mysql_config_editor command.
You need to check what is defined for this login-path to ensure that it is correct for your deployment.
You execute this command:
$ mysql_config editor print --loqin-path=adamlocal
What is the expected output of this command?
Question No : 15
What are two functions of the max_binlog_size variable?