单选题
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?（）
Activating the MySQL Enterprise thread pool plugin
Relocating your data and log files to separate storage devices
Disconnecting idle localhost client sessions
Implementing storage engine data compression options
多选题
Which three statements are characteristic of the MEMORY storage engine?（）
It can support transactions
Table contents are not saved if the server is restarted
It cannot contain text or BLOB columns
It can support foreign keys
Each table is represented on disk as an.frm file
Each table has a corresponding.MYI and .MYD file
多选题
Which three statements are true about memory buffer allocation by a MySQL Server?（）
Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed
Thread buffers are allocated when a client connects, and are freed when the client disconnects
Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends
User buffers are allocated at server startup and freed when the user is dropped
All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
单选题
The validate_password plugin is loaded and displays the following settings in global variables: Mysql＞ SHOW VARIABLES LIKE ‘validate_password%’; When attempting to set your password, you get the following error: Mysql＞ SET PASSWORD = PASSWORD (‘Hoverl@%’); ERROR 1819 (HY000): Your password does not satisfy the current policy requirements What is the cause of the error?（）
The password is eight characters long, but needs to exceed validate_password_length to be valid
All of the MEDIUM password policy requirements have not been honored
The password matches a substring Hover as a dictionary word
The password does not match the validate_passoword_number_count requirement
There is no dictionary file defined, so password validation cannot work as expected
单选题
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 information?（）
Include-master-info
Master-binlog
Include-log-file
Master-data
单选题
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?（）
The — ssl level was not specified
The server was not started with the – enable–ssl-plugin option
— ssl is not a valid server option
The mysqld binary was not compiled with SSL support
The server's SSL certificate was invalid
单选题
Which statement is true about the log-output variable?（）
It is a static variable and can be set only at MySQL server startup
It enables and starts the General Query Log
It sets the target location for the binary logs generated by the MySQL sever
It specifies output destinations for the slow and General Query logs
单选题
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）
12; only top-level statements and stored procedure events are logged
111; top-level statements and all lower-level statements are logged
3; only the top-level statements are logged
102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
单选题
Identify a performance impact when using the Performance Schema.（）
There is no impact on performance
The overhead depends on the settings of the Performance Schema
There is an overhead for querying the Performance Schema but not for having it enabled
There is a constant overhead regardless of settings and workload
单选题
Consider the following: Which statement best describes the meaning of the value for the key_len column?（）
It shows the total size of the index row
It shows how many columns in the index are examined
It shows the number of characters indexed in the key
It shows how many bytes will be used from each index row
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）