单项选择题
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
相关考题
-
多项选择题
Which two statements are true regarding partitioning in Mysql?（）
A.Tables with BLOB and TEXT columns cannot be partitioned
B.Partitioning allows easier management of smaller data sets for certain queries
C.Partitioning allows different columns to be stored in separate files
D.The partitioning expression is an integer or function that returns an integer value or NULL value
E.Partitioning is only available for those storage engines that implements it natively -
单项选择题
Which hardware storage option, when set up with redundant disks, offers the least stability,availability, and reliability for Mysql data?（）
A.RAID 5
B.iSCSI
C.SAN (Storage Area Network)
D.NFS (Networked File System) -
多项选择题
A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）
A.Disabling connections from named pipes or socket files (depending on the operating system of the server)
B.Enabling and using SSL for connections to the Mysql database
C.Installing Mysql on the application server, and running the database and application on the same server
D.Starting the server with – bind- address=0.0.0.0 specified
E.Running the server with – skip-networking specified
F.Limiting logins to originate from the application server or the server's subnet'
