单选题 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 you deployment. You execute this command: $mysql_config_editor print –login-path=adamlocal What is the expected output of this command?()
The command prints all parameter for the login-path. The password is replaced with stars
The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists
The command prints all parameters for the login-path. The password is shown only when you provide the –password option
The command prints all parameters for the login-path. The password is printed in plain tex
单选题 You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell> mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?()
It exports tables with the most indexes first to assist with import speeds
It ensures that unique indexes have no conflicts when the data is dumped
It orders by primary key to assist in speeding up importing to InnoDB tables
It must be specified so index data is dumped correctly when –on-create-info is used
多选题 Which two statements are true regarding partitioning in Mysql?()
Tables with BLOB and TEXT columns cannot be partitioned
Partitioning allows easier management of smaller data sets for certain queries
Partitioning allows different columns to be stored in separate files
The partitioning expression is an integer or function that returns an integer value or NULL value
Partitioning is only available for those storage engines that implements it natively
单选题 Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?()
A syntax error will result as you cannot specify more than one partition in the same statement
All data in p1 and p3 partitions are removed and the table definition is changed
All data in p1 and p3 partitions are removed, but the table definition remains unchanged
Only the first partition (p1) will be dropped as only one can be dropped at any time
单选题 You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?()
Increase the value of table_definition_cache
Increase the value of table_open_cache_instances
Decrease the value of table_open_cache_instances
Increase the value of table_open_cache
Decrease the value of table_definition_cache
Decrease the value of table_open_cache
多选题 Which three methods will show the storage engine for the Country table?()
A
B
C
D
E
多选题 Which two are correct steps in taking a binary backup of MyISAM tables?()
Always stop the server prior to the backup
Stop the server or lock the tables prior to the backup
Stop the server or lock the databases prior to the backup
Make a copy of the .frm, .myd, and the .myi files
Make a copy of the binary log and tablespace files
多选题 Which two are true regarding MySQL binary and text backups?()
Binary backups are usually faster than text backups
Binary backups are usually slower than text backups
Text backups are human-readable while binary backups are not
Binary backups are not portable across different operating systems
多选题 Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?()
Mysql NDB Cluster
Mysql Replication
Distributed Replicated Block Device (DRBD) and Mysql
Windows Cluster and Mysql
Solaris Cluster and Mysql
多选题 Which two statements are true about setting the per-thread buffers higher than required?()
More memory per thread is beneficial in all scenarios
It causes increased overhead due to initial memory allocation
It can affect system stability during peak load times, due to swapping
It requires increasing the thread_cache_size variable
在任何情况下,伸缩调节器处轨距的要求为()。
人类有两套影响学习的记忆系统:陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆,就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式,比如骑自行车。在很多时候,这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西,比如语法规则。帮助人们学习词汇的陈述性记忆系统,则需要更多时问完成发育。儿童拥有程序记忆系统,并且不受陈述性记忆系统的干扰。由此可以推出()。
宋末元初四大家
公平目标的实现可以通过()实现。
荟萃分析
人员安全疏散分析的性能判定标准为:可用疏散时间(A.SET)必须()必需疏散时间(RSET)。
预防HIV感染的主要措施应当为( )
简述我国混合型债券市场的发展状况。
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指()
输血的适应证中,不包括()