单选题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.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 valueB.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.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 serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

2.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 nodeB.Only MySQL can maintain a time-delayed copy of data on the secondary nodeC.Both technologies use the TCP/IP stack as their primary transmission mediumD.DRBD uses shared-disk technology

3.When backing up a replication slave, which three should also be backed up in addition to data?()A.The master.info and relay.info filesB.The relay log filesC.The relay index fileD.Mysql.slave_master_info tableE.Mysql.slave_relay_log_info tableF.Mysql.slave_worker_info table

4.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.sqlB.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows functionC.For tables with UNIQUE keys, statement-based replication must be used maintain integrityD.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewriteE.The applications have the SUPER privilege, which allows them to update rows

更多“单选题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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

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

  • 第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.MASTER
    B.STANDBY SLAVE
    C.PARKED.SLAVE
    D.ACTIVE SLAVE

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

  • 第5题：

    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

  • 第6题：

    使用“show board”命令可以检查UAP3300各槽位板子的状态是否正常，主用SMCU板的状态值应该是（）。

    • A、MASTER_OK
    • B、SLAVE_OK
    • C、MASTER
    • D、SLAVE

    正确答案:A

  • 第7题：

    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

    正确答案:C

  • 第8题：

    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、STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383
    • B、STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383
    • C、STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE
    • D、STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE

    正确答案:C

  • 第9题：

    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

  • 第10题：

    单选题
    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

    STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383

    B

    STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383

    C

    STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE

    D

    STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-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


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    The technician is working on a system and has determined that the hard drive must be reimaged. However, the customer wants to retain all the data. Which of the following would take the LEAST amount of time to implement?（）
    A

    Create a new partition on the hard drive, copy all data to the new partition, reimage the drive, and the old data will be on the new partition and accessible.

    B

    Install a new hard drive, slave the old drive, image the new drive, and show the customer how to access their data on the old drive.

    C

    Upload the data to an external FTP server, reimage the drive, and then restore the data to the newly imaged drive.

    D

    Copy data to a USB connected hard drive, reimage the drive, and then restore the data to the newly imaged drive.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    试题（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

  • 第15题：

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

  • 第16题：

    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.MASTER-TO-MASTER
    B.MASTER-TO-SLAVE
    C.SLAVE-TO-SLAVE
    D.SLAVE-TO-MASTER

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

  • 第17题：

    在给硬盘跳线时，我们常常会看到“Master”和“Slave”标记，它们的含义分别为（）。

    • A、“Master”为主盘、”Slave”为从盘
    • B、“Master”为从盘、”Slave”为从盘
    • C、“Master”为第一IDE接口硬盘、“slave”第二IDE接口硬盘
    • D、”Master”为第二IDE接口硬盘、“Slave”第一IDE接口硬盘

    正确答案:A

  • 第18题：

    The technician is working on a system and has determined that the hard drive must be reimaged. However, the customer wants to retain all the data. Which of the following would take the LEAST amount of time to implement?（）

    • A、Create a new partition on the hard drive, copy all data to the new partition, reimage the drive, and the old data will be on the new partition and accessible.
    • B、Install a new hard drive, slave the old drive, image the new drive, and show the customer how to access their data on the old drive.
    • C、Upload the data to an external FTP server, reimage the drive, and then restore the data to the newly imaged drive.
    • D、Copy data to a USB connected hard drive, reimage the drive, and then restore the data to the newly imaged drive.

    正确答案:D

  • 第19题：

    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

  • 第20题：

    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: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-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

  • 第21题：

    如果在主板的一个IDE插口上同时接上硬盘和光驱，硬盘应该设置

    • A、Master Slave
    • B、Master Master
    • C、Slave Master
    • D、Slave Slave

    正确答案:A

  • 第22题：

    多选题
    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


    正确答案： D,F
    解析： 暂无解析

  • 第23题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

相关内容