单选题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?()ASTOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVEBSTOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVECSTOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVEDSTOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE

单选题
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


参考解析

解析: 暂无解析

相关考题:

Certkiller.com has given you the task of serializing an object and writing it to a data file using binary serialization.You need to ensure that you meet these requirements.What should you do?() A.B.C.D.

You need to write a code segment that transfers the contents of a byte array named dataToSendby using a NetworkStream object named netStream.You need to use a cache of size 8,192 bytes.Which code segment should you use?()A.B.C.D.

You are using VHF channel 16 (156.8 MHz) or 2182 KHz. You need help but are not in danger. You should use the urgent signal ______.A.ASSISTANCE NEEDEDB.PAN-PANC.MAYDAYD.SECURITE

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 SLAVEB.STOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVEC.STOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVED.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE

You have a computer that runs Windows Vista. You create a dial-up connection.You need to run a custom script each time you connect by using the dial-up connection.What should you do?() A.AB.BC.CD.D

You need to connect to your computer by using the Remote Desktop Connection client.Which two actions should you perform?() A.AB.BC.CD.DE.E

You install Windows Vista on a new computer by using the retail installation media.You install a new hardware device. You are not prompted for any drivers and the installation completes successfully.You discover that an updated driver is available for the hardware device.You need to install the updated driver.What should you do?()A.AB.BC.CD.D

Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups?()A、 You need to mention it with every BACKUP command.B、 The block change tracking feature is used automatically by RMAN.C、 You need to configure it using the CONFIGURE command.D、 You need to set the necessary initialization parameters to direct RMAN to use the feature.

You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A、 You do not need to restore all the data files.B、 You do not need to open the database with the RESETLOGS operationC、 You do not need to perform a full backup after the RESETLOGS operation.D、 You do not need to recover all the data files to the same system change number (SCN).

You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5.  An exception management framework is not used in the Web application. You need to ensure thatthe application log the unhandled exceptions automatically to the event log. You need to configurethe Web.config file to accomplish this. Identify the configuration that will assist you in thisscenario?()A、You should consider using the healthMonitoring enabled="true"/ configuration.B、You should consider using the deployment retail="true"/ configuration.C、You should consider using the customErrors mode="On"/ configuration.D、You should consider using the trace enabled="true"/ configuration.

You plan to deploy Windows 7 images. You need ensure that you can deploy images by using the WindowsPreinstallation Environment (Windows PE).  What should you do add to the Windows PE image?()A、Imagex.exeB、Loadstate.exeC、Mighost.exeD、Usmtutils.exe

Windows NT 4.0 is currently on the system you are using, and you want to install Windows 2000 Professional. Windows NT 4.0 is currently on an NFTS partition.  For some reason you have decided that you are not going to upgrade, but rather, you are going to run this in a dual boot fashion.  What do you need to do? ()A、Can’t be done.B、You need to put Windows 2000 on a separate partition from Windows NT 4.0C、You need to put Windows 2000 on the same partition as Windows NT 4.0.D、You need to upgrade Windows NT 4.0 to SP4.

You want users to log on to Active Directory by using a new User Principal Name (UPN).  You  need to modify the UPN suffix for all user accounts.     Which tool should you use()A、DsmodB、NetdomC、RedirusrD、Active Directory Domains and Trusts

You are installing an application on a computer that runs Windows Server 2008 R2. During  installation, the application will need to add new attributes and classes to the Active Directory  database.     You need to ensure that you can install the application.     What should you do()A、Change the functional level of the forest to Windows Server 2008 R2.B、Log on by using an account that has Server Operator rights.C、Log on by using an account that has Schema Administrator rights and the appropriate rights to install the applicatioD、Log on by using an account that has the Enterprise Administrator rights and the appropriate rights to install the app

You need to recommend a solution for Group Policy that meets the companys technical requirements.What should you recommend?()A、Create a Central Store.B、Enable folder redirection.C、Modify the File Replication Service (FRS) settings for SYSVOL.D、Configure SYSVOL to use Distributed File System (DFS) Replication.

You need to recommend a solution for managing administrative rights for the branch office client computers. The solution must meet the companys technical requirements.What should you recommend configuring?()A、Account Policies by using GPOsB、Local Users and Groups by using Group Policy preferencesC、Restricted Groups by using GPOsD、Security Options by using Group Policy preferences

You have a server that runs Windows Server 2003 Service Pack 2 (SP2). You create an Automated System Recovery (ASR) backup of the server. You restart the server and receive a critical error. You need to restore the server by using ASR. What should you do first? ()A、Start the computer by using Safe mode.B、Start the server by using the ASR floppy disk.C、Start the computer by using the Last Known Good Configuration option.D、Start the server by using the Windows Server 2003 SP2 installation media.

You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 is configured as an enterprise root certification authority (CA). You need to back up the CA's database and log files. You must achieve this goal by using the minimum amount of disk space. What should you run? ()A、Certreq.exe by using the –new parameterB、Certutil.exe by using the -backup parameterC、Cipher.exe by using the /k parameterD、Ntbackup.exe by using the systemstate parameter

You are creating a Windows Forms application by using the .NET Framework 3.5 The application is used by a financial service provider.You discover that the service provider transfers large amounts of data by using XML.You need to read and validate the XMLdocuments in the most time efficient manner.Which technology should you use?()A、The XmlReader classB、The XmlDocument classC、The XmlResolver classD、The LINQ to XML method

单选题After you back up /export using a file system snapshot, and you have removed the snapshot, you also need to remove the backing store. If the snapshot was created with:  # mkdir /var/tmp/backup-snaps  # fssnap -o  bs=/var/tmp/backup-snaps /export   Which file do you need to remove? ()A AB BC CD D

单选题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?()ASTOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVEBSTOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVECSTOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVEDSTOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE

单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A You do not need to restore all the data files.B You do not need to open the database with the RESETLOGS operationC You do not need to perform a full backup after the RESETLOGS operation.D You do not need to recover all the data files to the same system change number (SCN).

单选题You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5.  An exception management framework is not used in the Web application. You need to ensure thatthe application log the unhandled exceptions automatically to the event log. You need to configurethe Web.config file to accomplish this. Identify the configuration that will assist you in thisscenario?()AYou should consider using the healthMonitoring enabled=true/ configuration.BYou should consider using the deployment retail=true/ configuration.CYou should consider using the customErrors mode=On/ configuration.DYou should consider using the trace enabled=true/ configuration.

单选题Windows NT 4.0 is currently on the system you are using, and you want to install Windows 2000 Professional. Windows NT 4.0 is currently on an NFTS partition.  For some reason you have decided that you are not going to upgrade, but rather, you are going to run this in a dual boot fashion.  What do you need to do? ()ACan’t be done.BYou need to put Windows 2000 on a separate partition from Windows NT 4.0CYou need to put Windows 2000 on the same partition as Windows NT 4.0.DYou need to upgrade Windows NT 4.0 to SP4.

单选题You have a computer that runs Windows 7. You need to identify the disk, memory, CPU, and networkresources that an application is currently using.  Which tool should you use?()AComponent ServicesBPerformance Information and ToolsCReliability MonitorDResource Monitor

单选题Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()AYou need to perform the restore and recover operations manually, because the backup was made manually. BFirst you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. CFirst you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. DYou can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

单选题You plan to deploy Windows 7 images. You need ensure that you can deploy images by using the WindowsPreinstallation Environment (Windows PE).  What should you do add to the Windows PE image?()AImagex.exeBLoadstate.exeCMighost.exeDUsmtutils.exe