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

A MySQL replication slave is set up as follows: User all Inn

题目
多选题
A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary logs Has the read-only option The 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: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’ Error_code: 1062 2013-08-27 13:55:44 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 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

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

第1题：

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

第2题：

What are three actions performed by the mysql_secure_installation tool?()

A.It prompts you to set the root user account password

B.It checks whether file permissions are appropriate within datadir

C.It asks to remove the test database, which is generated at installation time

D.It can delete any anonymous accounts

E.It verifies that all users are configuration with the longer password hash


参考答案：A, C, D

第3题：

Which three statements are true about memory buffer allocation by a MySQL Server?()

A.Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed

B.Thread buffers are allocated when a client connects, and are freed when the client disconnects

C.Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends

D.User buffers are allocated at server startup and freed when the user is dropped

E.All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed


参考答案：A, B, C

第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题：

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

第6题：

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

第7题：

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

第8题：

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

第9题：

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

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

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

更多相关问题
相关内容