网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（）
A
Both technologies guarantee an identical copy of data on the secondary node
B
Only MySQL can maintain a time-delayed copy of data on the secondary node
C
Both technologies use the TCP/IP stack as their primary transmission medium
D
DRBD uses shared-disk technology
参考答案
参考解析
解析：
暂无解析
更多 “多选题Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（）ABoth technologies guarantee an identical copy of data on the secondary nodeBOnly MySQL can maintain a time-delayed copy of data on the secondary nodeCBoth technologies use the TCP/IP stack as their primary transmission mediumDDRBD uses shared-disk technology” 相关考题
考题
单选题Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （ ） functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?（）A
Convert the column to TEXT and add a fulltext index to the tableB
Create multiple prefix indexes of differing lengthsC
Convert their column to BINARYD
Redesign the table so that the most commonly searched for string patterns are in their own columns
考题
单选题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?（）A
Mysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration fileB
An error message is issued because – install is not a valid option for mysqldC
A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnfD
Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file
考题
单选题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?（）A
The command prints all parameter for the login-path. The password is replaced with starsB
The command prints the encrypted entry for the login-path. The is only possible to see if an entry existsC
The command prints all parameters for the login-path. The password is shown only when you provide the –password optionD
The command prints all parameters for the login-path. The password is printed in plain tex
考题
单选题A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）A
It deletes all binary log files, except 'mysql-in.010'B
It deletes all binary log files up to and including 'mysql-bin.010'C
It deletes all binary log files before 'mysql-bin.010'D
It deletes all binary log files after 'mysql-bin.010'
考题
多选题Which three statements describe how the strict SQL mode provides added security?（）AIt rejects statements that try to insert out-of-range valuesBIt rejects invalid datesCIt limits the operations that the server can performDIt rejects queries that produce out-of-range valuesEIt rejects dates with zero day or month values
热门标签
最新试卷