违法和不良信息举报 联系客服
免费注册 登录

单选题An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hos

题目
单选题
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）
A

Gtid_mode must be set to AUTO during point in time recoveries

B

Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs

C

The server keeps track of which GTIDs have already been executed and skips those

D

Enforce_gtid_consistency is set to ON

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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


参考答案：B, C

第2题：

You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa－bbb－cccddd－eee : 3 on a slave. Which command would you execute from a Mysql prompt?()

A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE

B.STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE

C.STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE

D.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE


参考答案：C

第3题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()

A.Each extra column in the copy with more columns must not have a default value

B.Columns that are common to both versions of the table must be defined in the same order on the master and the slave

C.The slave database cannot have more columns than the master. Only the master database can have more columns

D.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server

E.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns


参考答案：B, D

第4题：

A Bluetooth device can be either a master or a slave and any of the devices within a （ ）can be the master. There is only one master and there can be up to （请作答此空） active slave devices at a time within a single network. In addition, a device may be a standby slave or a parked slave. There can be up to （ ） parked slaves. If there are already maximum number of active slaves, then a parked slave must wait until one of the active slaves switches to （ ） mode before it can become active. Within a network, all （ ） communications are prohibited.

A.7
B.15
C.63
D.255

答案：A
解析：
解析：参考译文
蓝牙设备可以是一个主设备也可以是一个从设备，位于（ ）中的任一设备都可以成为主设备。在一个网络中只有一个主设备，最多有（请作答此空）个激活的从设备。另外，一个设备可以是活跃的从设备或是休眠的从设备，最多有（ ）个休眠的从设备。如果已有最大数量的活跃从设备，那么，一个休眠的从设备就必须等到某活跃从设备切换到（ ）模式后才能被激活。在一个网络内，所有的（ ）通信都是被禁止的。

第5题：

A simple master－to－slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY

A.SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"

B.SET GLOBAL enforce_gtid_consistency=ON

C.SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9"

D.SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"

E.SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1


参考答案：E

第6题：

When backing up a replication slave, which three should also be backed up in addition to data?()

A.The master.info and relay.info files

B.The relay log files

C.The relay index file

D.Mysql.slave_master_info table

E.Mysql.slave_relay_log_info table

F.Mysql.slave_worker_info table


参考答案：A, B, C

第7题：

ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1;Can‘t find record in ‘t1‘, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event‘s master log 56_master-bin. 000003, end_log_pos 851, Error_code: 10322013-08-27 14:15:47 9056 [warning] Slave: Can‘t find record in ‘t1‘ Error_code: 10322013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START".We stopped at log ‘56_masterbin. 000003‘ position 684 Why did you receive this error?（）

A.The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s

B.The table definition on the slave -litters from the master

C.Multi-threaded replication slaves can have temporary errors occurring for cross database updates

D.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist


参考答案：D

第8题：

A MySQL replication slave is set up as follows: User all InnoDB tablesReceives ROW-based binary logs Has the read-only optionThe replication slave has been found in an error state.You check the MySQL error log file and find the following entries:2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 10622013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’Error_code: 10622013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix theproblem, and restart the slave SQL thread with SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?（）

A.The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql

B.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function

C.For tables with UNIQUE keys, statement-based replication must be used maintain integrity

D.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite

E.The applications have the SUPER privilege, which allows them to update rows


参考答案：A, E

第9题：

试题（71）～（75）

A Bluetooth device can be either a master or a slave and any of the devices within a （71）can be the master. There is only one master and there can be up to （72） active slave devices at a time within a single network. In addition, a device may be a standby slave or a parked slave. There can be up to （73） parked slaves. If there are already maximum number of active slaves, then a parked slave must wait until one of the active slaves switches to （74） mode before it can become active. Within a network, all （75） communications are prohibited.

（71）

A. Wireless LAN

B. Wireless MAN

C. Cellular radio network

D. Piconet

（72）

A. 7

B. 15

C. 63

D. 255

（73）

A. 127

B. 255

C. 511

D. 1023

（74）

A. master

B. standby slave

C. parked slave

D. active slave

（75）

A. master-to-master

B. master-to-slave

C. slave-to-slave

D. slave-to-master


正确答案：D,A,B,C,C
参考译文
蓝牙设备可以是一个主设备也可以是一个从设备，位于（71）中的任一设备都可以成为主设备。在一个网络中只有一个主设备，最多有 （72）个激活的从设备。另外，一个设备可以是活跃的从设备或是休眠的从设备，最多有（73）个休眠的从设备。如果已有最大数量的活跃从设备，那么，一个休眠的从设备就必须等到某活跃从设备切换到（74）模式后才能被激活。在一个网络内，所有的（75）通信都是被禁止的。
参考答案
（71）D  （72）A  （73）B  （74）C  （75）C

第10题：

A Bluetooth device can be either a master or a slave and any of the devices within a （请作答此空）can be the master. There is only one master and there can be up to （ ） active slave devices at a time within a single network. In addition, a device may be a standby slave or a parked slave. There can be up to （ ） parked slaves. If there are already maximum number of active slaves, then a parked slave must wait until one of the active slaves switches to （ ） mode before it can become active. Within a network, all （ ） communications are prohibited.

A.WIRELESS LAN
B.WIRELESS MAN
C.CELLULAR RADIO NETWORK
D.PICONET

答案：D
解析：
解析：参考译文
蓝牙设备可以是一个主设备也可以是一个从设备，位于（请作答此空）中的任一设备都可以成为主设备。在一个网络中只有一个主设备，最多有（ ）个激活的从设备。另外，一个设备可以是活跃的从设备或是休眠的从设备，最多有（ ）个休眠的从设备。如果已有最大数量的活跃从设备，那么，一个休眠的从设备就必须等到某活跃从设备切换到（ ）模式后才能被激活。在一个网络内，所有的（ ）通信都是被禁止的。

更多相关问题
相关内容