单选题An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?()AGtid_mode must be set to AUTO during point in time recoveriesBMysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDsCThe server keeps track of which GTIDs have already been executed and skips thoseDEnforce_gtid_consistency is set to ON

单选题
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?()
A

Gtid_mode must be set to AUTO during point in time recoveries

B

Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs

C

The server keeps track of which GTIDs have already been executed and skips those

D

Enforce_gtid_consistency is set to ON


参考解析

解析: 暂无解析

相关考题:

Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?() A.Both technologies guarantee an identical copy of data on the secondary nodeB.Only MySQL can maintain a time-delayed copy of data on the secondary nodeC.Both technologies use the TCP/IP stack as their primary transmission mediumD.DRBD uses shared-disk technology

You would like to view all Fast Ethernet interfaces currently using VLAN tagging and the specific VLANs each interface is using.Which CLI command displays this information?() A.AB.BC.CD.D

You are the administrator of a network that includes Windows NT Server 4.0 computers, Windows NT Workstation 4.0 computers, and UNIX computers. The network consists of a single Windows NT domain.You are upgrading a Windows NT Server computer named Server1 to Windows 2000 Server. Server1 is a BDC in the domain. The existing DNS server is a UNIX computer that supports SRV (service) records and is configured to accept dynamic updates. The existing WINS server is another Windows NT Server computer.You want to configure Server1 as a domain controller in a New Active Directory forest. You want the existing Windows NT domain accounts to be upgraded to Active Directory. You plan to upgrade the other domain controllers in the domain to Windows 2000 after the upgrade of Server1 is complete.You want to perform. the upgrade of Server1 with the least possible impact on other computers on the network. What should you do?A.Promote Server1 to the PDC of the domain. Run Windows 2000 Setup on Server1.B.Run Windows 2000 Setup on Server1. At the end of Setup, configure Server1 as a DNS server and a WINS server.C.Add a static mapping for Server1 on the WINS server. On the DNS server, create an SRV record for the LDAP service on Server1. Run Windows 2000 Setup on Server1.D.Install the Microsoft DNS service on an existing Windows NT server. Apply Windows NT 4.0 service pack 4 or later to the server. Run Windows 2000 Setup on Server1.

An administrator is troubleshooting a communication issue between two computers on the sameLayer 2 switch.Which of the following is the BEST way to determine if the switch is causing the issue?() A. Setup an ACL that allows and logs all IP traffic between the two computersB. Configure a spanning tree to check for a loopC. Setup a span port on the switch to watch for CRC errorsD. Connect both computers using a crossover cable

AVIOserverhastwofibrechanneladapters,fcs0fcs1,attachedforredundantaccesstoastoragesubsystem.Iffcs1hasfailed,whatisthecorrectproceduretorectifythisproblem?() A.Using’diagmenu’command,setfcs1toDefined.B.Using’oem_setup_env’and’rmdev-R’commands,setfcs1adapterto’Defined’state.C.Using’diagmenu’command,setthefcs1statetoDefinedD.Using’oem_setup_env’and’rmdev-dl’commands,setthestateoffcs1toDefined

A VIO server has two fibre channel adapters, fcs0 fcs1, attached for redundant access to a storage subsystem.  If fcs1 has failed, what is the correct procedure to rectify this problem? ()A、 Using ’diagmenu’ command, set fcs1 to Defined.B、 Using ’oem_setup_env’ and ’rmdev -R’ commands, set fcs1 adapter to ’Defined’ state.C、 Using ’diagmenu’ command, set the fcs1 state to DefinedD、 Using ’oem_setup_env’ and ’rmdev -dl’ commands, set the state of fcs1 to Defined

You are designing a plan to migrate an existing application to Windows Azure.  The application currently resides on a server that has 768 MB of memory and multiple cores. You need to recommend the smallest compute instance size that is equivalent to the existing server.  Which size should you recommend?()A、 SmallB、 MediumC、 LargeD、 ExtraSmall

An administrator is troubleshooting a communication issue between two computers on the same Layer 2 switch. Which of the following is the BEST way to determine if the switch is causing the issue?()A、Setup an ACL that allows and logs all IP traffic between the two computersB、Configure a spanning tree to check for a loopC、Setup a span port on the switch to watch for CRC errorsD、Connect both computers using a crossover cable

Which of the following should be done during a Windows server OS installation to install third party drivers for a storage array controller?()A、 Use recovery console from Windows setup.B、 Have the manufacturer’s driver disk in the floppy drive and Windows will install it automatically.C、 Press F6 when prompted during the setup utility.D、 Run setup using the appropriate installation wizard.

Companycom would like the ability to shrink filesystems. They currently have JFS filesystems. Which of the following is necessary to shrink the filesystems?()A、Copy the existing filesystems to JFS2B、Defragment the filesystem, then reduce its sizeC、Change the file system attribute allow_shrink=yes on the existing filesystemsD、Modify the logical volume attribute allow_shrink=yes on the existing logical volumes

Using a policy with the policy-rematch flag enabled, what happens to the existing and new sessionswhen you change the policy action from permit to deny? ()A、The new sessions matching the policy are denied. The existing sessions are dropped.B、The new sessions matching the policy are denied. The existing sessions, not being allowed to carry any traffic, simply timeout.C、The new sessions matching the policy might be allowed through if they match another policy. The existing sessions are dropped.D、The new sessions matching the policy are denied. The existing sessions continue until they are completed or their timeout is reached.

Which is not a valid way of backing up a control file?()  A、 Backing up the control file to traceB、 Copying the existing control file of the database to the backup location during a hot backup C、 Copying the existing control file of the database to the backup location during a cold backupD、 Creating a backup control fileE、 Using the create controlfile command

You are designing a plan to migrate an existing application to Windows Azure. The application currently resides on a server that has 20 GB of hard disk space.  You need to recommend the smallest compute instance size that provides local storage equivalent to that of the existing server.  Which size should you recommend?()A、 ExtraSmallB、 ExtraLargeC、 SmallD、 Large

You are preparing the supporting network infrastructure for the upgrade to Exchange Server 2003. You want to accomplish this upgrade by using the minimum amount of administrative effort.Which two actions should you perform?()A、Run the setup.exe /domainprep command on a domain controller in the prod.testking.com domainB、Run the setup.exe /domainprep command on a domain controller in the app.testking.com domainC、Run the setup-exe /domainprep command on a domain controller in the testking.com domainD、Log on to the domain by using a user account that is a member of the Domain Admins groupE、Log on to the domain by using a user account that is a member of the Schema Admins group

单选题View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table:   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY (emp_id)   USING INDEX emp_id_idx;   Which statement is true regarding the effect of the command?()A  The PRIMARY KEY is created along with a new index.B  The PRIMARY KEY is created and it would use an existing unique index.C  The PRIMARY KEY would be created in a disabled state because it is using an existing index.D  The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.

单选题An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?()AGtid_mode must be set to AUTO during point in time recoveriesBMysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDsCThe server keeps track of which GTIDs have already been executed and skips thoseDEnforce_gtid_consistency is set to ON

单选题A customer wants to deploy the Cisco Business Ready Teleworker solution, but is currently using a traditional (non-IP) PBX for voice services. What would you recommend to this customer?()ADeployment of Business Ready Teleworker with VoIP is not recommended.BThe customer’s existing PBX must first be replaced with Cisco IP Telephony solution.CBusiness Ready Teleworker and Cisco IP Telephony can be deployed in parallel to the existing PBX, integrating the two with trunking.DDeployment is recommended only for full-time Teleworkers who have no other corporate phone.

单选题Which is not a valid way of backing up a control file?()A Backing up the control file to traceB Copying the existing control file of the database to the backup location during a hot backup C Copying the existing control file of the database to the backup location during a cold backupD Creating a backup control fileE Using the create controlfile command

单选题You are designing a plan to migrate an existing application to Windows Azure. The application currently resides on a server that has 20 GB of hard disk space.  You need to recommend the smallest compute instance size that provides local storage equivalent to that of the existing server.  Which size should you recommend?()A ExtraSmallB ExtraLargeC SmallD Large

单选题An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?()ASTOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383BSTOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383CSTOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVEDSTOP SLAVE; SET GLOBAL master_delay =0; START SLAVE

单选题You are the desktop administrator for your company's sales department. You need to perform a clean installation of Windows XP Professional on a computer that currently runs Windows 98. You start the installation. The text-based portion of Setup finishes successfully. Before the GUI-based portion of Setup starts, the computer stops responding. You investigate and discover that there is a problem with a device driver.  You want to know which device is causing the problem. What should you do?()AModify the Boot.ini file to include the /fastdetect switch.BModify the Boot.ini file to include the /sos switch.CRestart Setup by using the /dudisable switch.DRestart Setup by using the /dushare switch. ERestart the computer. From the Recovery console, read the Dr. Watson log.FRestart the computer. From the Recovery console, read the Comsetup.log file.

多选题Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?()ABoth technologies guarantee an identical copy of data on the secondary nodeBOnly MySQL can maintain a time-delayed copy of data on the secondary nodeCBoth technologies use the TCP/IP stack as their primary transmission mediumDDRBD uses shared-disk technology

单选题You are the desktop administrator for your company. You need to upgrade a Windows 98 computer to Windows XP Professional. Windows 98 is installed in a folder named C:/Win98.  You need to ensure that the computer's applications and settings are retained after the upgrade. You insert the Windows XP Professional CD-ROM into the computer and restart the computer. The text-based portion of Setup appears. The text on the screen states that Windows XP Professional will be installed in a folder named C:/Windows, not in the C:/Win98 folder.  You need to ensure that Windows XP Professional upgrades the existing Windows 98 installation. What should you do?()ARename the C:/Win98 folder to C:/Windows. BModify the installation settings in the text-based portion of Setup so that Windows XP Professional is installed in the C:/Win98 folder. CRestart the computer by using Windows 98. Then insert the Windows XP Professional CD-ROM into the computer and run Setup from the CD-ROM. DUse the Windows XP Professional CD-ROM to create a set of Setup floppy disks. Restart the computer by using the first floppy disk in the set to launch Setup.

单选题A VIO server has two fibre channel adapters, fcs0 fcs1, attached for redundant access to a storage subsystem.  If fcs1 has failed, what is the correct procedure to rectify this problem? ()A Using ’diagmenu’ command, set fcs1 to Defined.B Using ’oem_setup_env’ and ’rmdev -R’ commands, set fcs1 adapter to ’Defined’ state.C Using ’diagmenu’ command, set the fcs1 state to DefinedD Using ’oem_setup_env’ and ’rmdev -dl’ commands, set the state of fcs1 to Defined

单选题Which of the following should be done during a Windows server OS installation to install third party drivers for a storage array controller?()A Use recovery console from Windows setup.B Have the manufacturer’s driver disk in the floppy drive and Windows will install it automatically.C Press F6 when prompted during the setup utility.D Run setup using the appropriate installation wizard.

单选题You are the desktop administrator for Company.com’s sales department. Company.com’s network contains a RIS server.  You need to install Windows 2000 Professional on a computer that has a SCSI disk subsystem. You start the computer by using the Windows 2000 Professional CD-ROM, and you begin the installation. However, Setup reports that it cannot find any disk on which to install Windows 2000 Professional. You start the computer by using a RIS bootable floppy disk, and you receive the same result. What should you do?()A Add an answer file to the root directory of the RIS bootable floppy disk.      Start the computer by using the RIS bootable floppy disk, and run Setup by using RIS. B Add the SCSI-controller driver to the root directory of the RIS bootable floppy disk.     Start the computer by using the RIS bootable floppy disk, and run Setup by using RIS. C Start the computer by using the Windows 2000 Professional CD-ROM, and run Setup.     After Setup starts, provide an answer file on a floppy disk. D Start the computer by using the Windows 2000 Professional CD-ROM, and run Setup.     After Setup starts, provide a SCSI-controller driver on a floppy disk. E Start the computer by using the Windows 2000 Professional CD-ROM, and run Setup.     After Setup starts, provide the appropriate HAL on a floppy disk.

单选题Using a policy with the policy-rematch flag enabled, what happens to the existing and new sessionswhen you change the policy action from permit to deny? ()AThe new sessions matching the policy are denied. The existing sessions are dropped.BThe new sessions matching the policy are denied. The existing sessions, not being allowed to carry any traffic, simply timeout.CThe new sessions matching the policy might be allowed through if they match another policy. The existing sessions are dropped.DThe new sessions matching the policy are denied. The existing sessions continue until they are completed or their timeout is reached.

单选题You disabled the Flashback Database feature by using the following command:  SQL ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs?()AFlashback logs are not deleted.BFlashback logs are deleted automatically.CFlashback logs are deleted only if you are using Recovery Manager (RMAN).DFlashback logs are deleted only if you are using Oracle Managed Files (OMF).EFlashback logs are deleted only if you are using Automatic Storage Management (ASM).