单选题
A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）
The Query Cache is pruning queries due to an increased number of requests
Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups
Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded nature
The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution
多选题
A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）
Disabling connections from named pipes or socket files (depending on the operating system of the server)
Enabling and using SSL for connections to the Mysql database
Installing Mysql on the application server, and running the database and application on the same server
Starting the server with – bind- address=0.0.0.0 specified
Running the server with – skip-networking specified
Limiting logins to originate from the application server or the server's subnet'
单选题
You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tail – n2 /var/lib.mysql/hostname.err 2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: '5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock' port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) 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?（）
The RPM installation script sets a default password of password for new installations
The local root user must log in with a blank password initially: mysql –u root –p
New security measures mean that the mysql_secure_installation script must be run first on all new installations
The mysql_install_bd post-installation script used – random-password
单选题
You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?（）
STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
STOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVE
STOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVE
STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
单选题
Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）
MySQL Replication
Distributed Replication Block Device
Windows Server Failover Clustering
MySQL Cluster
多选题
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 the service did not start?（）
FORCE_PLUS_PERMANENT is not valid for the audit-log option
The audit_log.so library does not exist
The audit_log.so library is in a location that is different from that defined by the plugin_dir option
The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command
The audit log file does not exist in which to write audit events
The audit_log.so library is not an executable file
单选题
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）
Mysqlaccess
Mysqldump
Mysqlshow
Mysqlslow
Mysqldumpslow
单选题
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）
STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383
STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383
STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE
STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE
多选题
When backing up a replication slave, which three should also be backed up in addition to data?（）
The master.info and relay.info files
The relay log files
The relay index file
Mysql.slave_master_info table
Mysql.slave_relay_log_info table
Mysql.slave_worker_info table
单选题
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: /＞ mysqld – install Mysql56 – defaults – file = C :/my –opts.cnf What is the expected outcome?（）
Mysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration file
An error message is issued because – install is not a valid option for mysqld
A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnf
Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）