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' ' on query. Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') ' Skip_Counter: 0 Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1 You execute a "SHOW CREATE TABLE mytable" on the slave: CREATE TABLE 'mytable' ( 'ID' int(11) NOT NULL DEFAULT '0', 'name' char(10) DEFAULT NULL, PRIMARY KEY ('ID') ) The table mytable on the slave contains the following: You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?（） -题库考试答案搜索网

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' ' on query. Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') ' Skip_Counter: 0 Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1 You execute a "SHOW CREATE TABLE mytable" on the slave: CREATE TABLE 'mytable' ( 'ID' int(11) NOT NULL DEFAULT '0', 'name' char(10) DEFAULT NULL, PRIMARY KEY ('ID') ) The table mytable on the slave contains the following: You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?（）

单选题

2022-10-08 14:32

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

查看答案

正确答案

试题解析

标签： CMS专题

感兴趣题目

设a=5，b=4，c=3，d=2下列表达式的值是 3＞2*b Or a=c And b＜＞C Or c＞d

设a=5，b=4，c=3，d=2下列表达式的值是（）。3 > 2 * b Or a = c And b <> c Or c > d

设a=5，b=4，c=3，d=2，下列表达式的值是 3＞2*b Or a=c And b＜＞c Or c＞d

设A=3，B=4，C=5，D=6，则表达式A>B And C<=D Or 2*A>C的值是False。

设a=2，b=3，c=4，d=5，下列表达式的值是（）。 3>2*b Or a=c And bc Or ba+c

设a=2，b=3，c=4，d=5，下列表达式的值是 Not a＜=C Or 4*c=b^2 And b＜＞a+c

A(n) ______ is a destructive program that fills a computer system with self-replicating information，clogging the system so that its operations are slowed or stopped．

设a=2，b=3，c=4，d=5，下列表达式的值是（）。 3>2*b Or a=c And b<>c Or b<>a+c

设a=′′a′′，b=′′b′′，c=′′c′′，d=′′d′′，执行语句x=IIf（（ad），′′A′′，′′B′′）后，x的值为（　　）。

64 A difficult B simplest C simple D most difficult

A c（） sentence contains two or more clauses， one of which is incorporated in the other.

A manufacturing company is using ProtecTIER TS7610 appliances in a spoke and hubconfiguration. ProtecTIER’s TS7610 replication technology at the hub will perform the followingaction on the replicated data being received：（）