多选题 In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.() Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql> TRUNCATE t1;
$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
Mysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
$ mysql – u root – p – h localhost test < /tmp/t1.sql
Mysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
$ mysqlinport – u root – p – h localhost test /tmp/t1.sql
多选题 Consider the Mysql Enterprise Audit plugin. The following event detail is found in the audit log: Which two points can be concluded from the given event?()
A connection as the user kate was successful
A connection failed due to authentication being unsuccessful
A connection was attempted via socket rather than TCP
A connection was blocked by a firewall or a similar security mechanism
A connection failed because the proxy user privileges did not match the login user
多选题 What are three facts about backups with mysqldump?()
Can back up a remote database server
Allow a consistent backup to be taken
Are always faster to restore than binary backups
Are able to back up specific items within a database
Create automatically compressed backups
Will lock all storage engines for duration of backup
多选题 You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?()
Shell> mysqladmin –u root –p shutdown
Shell> nmc mysql shutdown
Mysql> STOP PROCESS mysqld
Shell> /etc/init.d/mysql stop
Shell> service mysql safe_exit
Shell> pkill –u mysql mysqld_safe
Shell> net stop mysql
单选题 Consider the query: Mysql> SET @run = 15; Mysql> EXPLAIN SELECT objective, stage, COUNT (stage) FROM iteminformation WHERE run=@run AND objective=’7.1’ GROUP BY objective,stage ORDER BY stage; The iteminformation table has the following indexes; Mysql> SHOW INDEXES FROM iteminformation: This query is run several times in an application with different values in the WHERE clause in a growing data set. What is the primary improvement that can be made for this scenario?()
Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes
Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations
Drop the run_2 index because it has caused a conflict in the choice of key for this query
Execute the run_2 index because it has caused a conflict in the choice of key for this query
Add a composite index on (run,objective,stage) to allow the query to fully utilize an index
多选题 Which two requirements would lead towards a high availability solution?()
When uptime is critical
When data must be refactored
When application concurrency is static
When data loss is unacceptable
When application is a single point of failure
多选题 Which two events will cause a slave server to create a new relay log file?()
Execution of the FLUSH LOGS statement
Starting of the SQL thread
Reaching the slave_pendign _jobs_size_max limit
Execution of FULSH TABLES WITH READ LOCK
Starting of the I/O thread
多选题 Which two statements describe the behavior of the server's SQL mode?()
The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax
The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE
The server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value command
The server's SQL mode, when globally set on a slave server, applies to events sent from the master
多选题 Which two capabilities are granted with the SUPER privilege?()
Allowing a client to kill other client connections
Allowing a client to shut down the server
Allowing change of the server runtime configuration
Allowing client accounts to take over the account of another user
在任何情况下,伸缩调节器处轨距的要求为()。
人类有两套影响学习的记忆系统:陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆,就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式,比如骑自行车。在很多时候,这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西,比如语法规则。帮助人们学习词汇的陈述性记忆系统,则需要更多时问完成发育。儿童拥有程序记忆系统,并且不受陈述性记忆系统的干扰。由此可以推出()。
宋末元初四大家
公平目标的实现可以通过()实现。
荟萃分析
人员安全疏散分析的性能判定标准为:可用疏散时间(A.SET)必须()必需疏散时间(RSET)。
预防HIV感染的主要措施应当为( )
简述我国混合型债券市场的发展状况。
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指()
输血的适应证中,不包括()