试题详情
- 单项选择题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
关注下方微信公众号，在线模考后查看
热门试题
- You are
- 用于在启动实例时配置数据库，确定Orac
- （）是具有只读类型的表和视图集，存储了数
- The CUSTOMERS table
- Which SQL statement
- A new report proces
- Which statemen
- Which of the followi
- ViewtheExhibittoexam
- Given： What is
- The EMP table conta
- YouareworkingonaCATD
- What is true about s
- Identify three benef
- 撤销用户指定权限的命令是（）。
- Which two̳
- For which two constr
- Given： What is
- A team of programme
- You need to produce