多选题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
多选题
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
参考解析
解析:
暂无解析
相关考题:
单选题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?()AConvert the column to TEXT and add a fulltext index to the tableBCreate multiple prefix indexes of differing lengthsCConvert their column to BINARYDRedesign 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?()AMysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration fileBAn error message is issued because – install is not a valid option for mysqldCA running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnfDMysqld 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?()AThe command prints all parameter for the login-path. The password is replaced with starsBThe command prints the encrypted entry for the login-path. The is only possible to see if an entry existsCThe command prints all parameters for the login-path. The password is shown only when you provide the –password optionDThe 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?()AIt deletes all binary log files, except 'mysql-in.010'BIt deletes all binary log files up to and including 'mysql-bin.010'CIt deletes all binary log files before 'mysql-bin.010'DIt 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