Oracle
1Z0-883 · Question #53
1Z0-883 Question #53: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #53. The question stem and answer options stay visible for context.
Question
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?Options
- ASET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
- BSET GTID_NEXT="CONSISTENCY";
- CSET GLOBAL enforce_gtid_consistency=ON
- DSET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9";
- ESET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT;
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.