单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?()AStart the server with the – innodb_recover_options option set to FORCEBStart the server with the – innodb_force_recovery option set to a non-zero valueCStart the server as usual, and then execute the REPAIR TABLE commandDStart the server as usual, and then execute the CHECK TABLE command

单选题
Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?()
A

Start the server with the – innodb_recover_options option set to FORCE

B

Start the server with the – innodb_force_recovery option set to a non-zero value

C

Start the server as usual, and then execute the REPAIR TABLE command

D

Start the server as usual, and then execute the CHECK TABLE command


参考解析

解析: 暂无解析

相关考题:

Automatic data conversion will occur if which of the following happens?() A. The client and server have different NLS_LANGUAGE settings.B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.C. The client and server are in different time zones.D. The client requests automatic data conversion.E. The AUTO_CONVERT initialization parameter is set to TRUE.

In a Windows Server 2003 environment using PKI, a user encrypts several documents on a shared file server. That user account is then accidentally deleted. Which of the following must be configured in order to decrypt those files?()A. Key recovery administratorB. Key recovery agentC. Trusted root certificate storeD. Root certificate store

Which of the following is the BEST recovery method for a server that only aggregates report data and stores data on separate servers?() A. FullB. Disk imagingC. IncrementalD. Tape backup

A computer configured to use DHCP cannot locate a DHCP server. Automatic Private IP Address(APIPA) will assign which of the following addresse?() A.172.16.1.25B.169.254.1.25C.10.16.1.25D.192.168.1.25

Automatic data conversion will occur if which of the following happens?()A、 The client and server have different NLS_LANGUAGE settingsB、 The client and server character sets are not the same,and the database character set is not a strict superset of the client character setC、 The client and server are in different time zonesD、 The client requests automatic data conversionE、 The AUTO_CONVERT initialization parameter is set to TRUE

Which of the following is a distinguishing factor between data archiving and data backups?()A、Data archives are kept for disaster recovery purposes while data backups are kept for indefiniteperiods of time so that there is an information record.B、Data archives are kept for documentation purposes to easily recover data while data backupsare kept for immediate server recovery.C、Data archives are kept off-site for data warehousing purposes while data backups are keptlocally for immediate server recovery purposes.D、Data archives are kept for indefinite periods of time so there is a record while data backups arekept for disaster recovery purposes.

After applying a new driver to a NIC, the server reboots and fails to restart. Which of the following is the BEST way to resolve the problem?()A、Boot using recovery console and restore the previous driver.B、Boot the server, press F8 and access last known good configuration.C、Restore the server using last backup tape.D、Boot the server with ASR option.

A computer configured to use DHCP cannot locate a DHCP server. Automatic Private IP Address(APIPA) will assign which of the following addresse?()A、172.16.1.25B、169.254.1.25C、10.16.1.25D、192.168.1.25

Which of the following is the BEST way to ensure that a server is up-to-date with all updates as soon as they are released?()A、Automatic updates set to install once per weekB、Automatic updates set to install updates automaticallyC、Automatic updates set to download all updates automaticallyD、Manual updates done daily at noon

Which of the following is the BEST recovery method for a server that only aggregates report data and stores data on separate servers?()A、FullB、Disk imagingC、IncrementalD、Tape backup

Which of the following can be used to re-deploy a system configuration in a disaster recovery scenario?()A、System planB、System profileC、Critical console dataD、VIO server partition profile

A customer needs to test the failover capabilities of their cluster. Which of the following AIX commands, whenissued from the command line, will simulate a node crash and cause the cluster resource group running onthat server to fail over to another node?()A、clstopB、halt -qC、shutdown -FD、stopsrc -s cluster

You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;   How does RMAN find the control file autobackup?()A、 By using the trace file.B、 By using the alert log file.C、 By using the database IDD、 By using the server parameter file.E、 By using the V$CONTROLFILE view.F、 By using the autobackup format configuration setting.

Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()A、data filesB、control filesC、parameter fileD、online redo log filesE、server parameter file

You have an Exchange Server 2010 organization that contains two Hub Transport servers.  You need to design a recovery plan for the Hub Transport servers that meets the following requirements: .Restores all Windows settings .Restores all Exchange configurations.Minimizes administrative effort What should you include in the plan?()A、.Retention of Exchange server computer accounts in Active Directory .Backup and recovery of Windows system stateA recovery installation of Exchange Server 2010B、.Retention of Exchange server computer accounts in Active Directory .Backup and recovery of transport queues.A custom installation of Exchange Server 2010C、Recovery of Windows system state.Backup and recovery of transport queues.A typical installation of Exchange Server 2010D、Backup and recovery of Windows system state.A repair installation of Windows Server 2008.A typical installation of Exchange Server 2010

You have an Exchange Server 2010 organization that contains two Hub Transport servers.  You need to design a recovery plan for the Hub Transport servers that meets the following requirements:.Restores all Windows settings .Restores all Exchange configurations.Minimizes administrative effort What should you include in the plan?()A、.Retention of Exchange server computer accounts in Active Directory .Backup and recovery of Windows system stateA recovery installation of Exchange Server 2010B、.Retention of Exchange server computer accounts in Active Directory .Backup and recovery of transport queues.A custom installation of Exchange Server 2010C、Recovery of Windows system state.Backup and recovery of transport queues.A typicalinstallation of Exchange Server 2010D、Backup and recovery of Windows system state.A repair installation of Windows Server 2008.A typical installation of Exchange Server 2010

单选题After applying a new driver to a NIC, the server reboots and fails to restart. Which of the following is the BEST way to resolve the problem? ()A Boot using recovery console and restore the previous driver.B Boot the server, press F8 and access last known good configuration.C Restore the server using last backup tape.D Boot the server with ASR option.

单选题You have an Exchange Server 2010 organization that contains two Hub Transport servers.  You need to design a recovery plan for the Hub Transport servers that meets the following requirements: .Restores all Windows settings .Restores all Exchange configurations.Minimizes administrative effort What should you include in the plan?()A.Retention of Exchange server computer accounts in Active Directory .Backup and recovery of Windows system stateA recovery installation of Exchange Server 2010B.Retention of Exchange server computer accounts in Active Directory .Backup and recovery of transport queues.Acustom installation of Exchange Server 2010CRecovery of Windows system state.Backup and recovery of transport queues.A typical installation of Exchange Server 2010DBackup and recovery of Windows system state.A repair installation of Windows Server 2008.A typical installation of Exchange Server 2010

单选题You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 experiences a power failure and shuts down unexpectedly. You start the server and receive the following error message; “NTLDR is missing. Press Ctrl+Alt+Del to restart.” You need to ensure that you can run Windows Server 2003 on Server1. What should you do first? ()AStart Server1 and press F8.BStart Server1 by using the Windows Server 2003 SP2 installation media and access the Recovery Console.CCreate a MS-DOS startup disk. Start Server1 from the MS-DOS startup disk.DCreate an Automated System Recovery (ASR) floppy disk from a different Windows Server 2003 SP2 server. Start Server1 from the ASR floppy disk.

单选题Which of the following would you use to enable automatic media recovery for a database?()ASET AUTORECOVERY ONBSET RECOVERY ONCSET AUTO ONDYou cannot enable automatic media recovery.

单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?()AStart the server with the – innodb_recover_options option set to FORCEBStart the server with the – innodb_force_recovery option set to a non-zero valueCStart the server as usual, and then execute the REPAIR TABLE commandDStart the server as usual, and then execute the CHECK TABLE command

单选题In a Windows Server 2003 environment using PKI, a user encrypts several documents on a shared file server. That user account is then accidentally deleted. Which of the following must be configured in order to decrypt those files?()AKey recovery administratorBKey recovery agentCTrusted root certificate storeDRoot certificate store

单选题Automatic data conversion will occur if which of the following happens?()A The client and server have different NLS_LANGUAGE settingsB The client and server character sets are not the same,and the database character set is not a strict superset of the client character setC The client and server are in different time zonesD The client requests automatic data conversionE The AUTO_CONVERT initialization parameter is set to TRUE

单选题A computer configured to use DHCP cannot locate a DHCP server. Automatic Private IP Address(APIPA) will assign which of the following addresse?()A172.16.1.25B169.254.1.25C10.16.1.25D192.168.1.25

单选题You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell> mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?()AIt exports tables with the most indexes first to assist with import speedsBIt ensures that unique indexes have no conflicts when the data is dumpedCIt orders by primary key to assist in speeding up importing to InnoDB tablesDIt must be specified so index data is dumped correctly when –on-create-info is used

单选题After a critical service failure occurs the server keeps rebooting every fifteen minutes not giving anadministrator enough time to troubleshoot the failure.  Which of the following does the administrator need to do to allow enough time to work on the system to troubleshoot the problem?()AModify boot.ini fileBDisable automatic reboot on serviceCPress F6 at boot upDClear cache

单选题In a Windows Server 2003 environment using PKI, a user encrypts several documents on a shared file server. That user account is then accidentally deleted.  Which of the following must be configured inorder to decrypt those files?()A Key recovery administratorB Key recovery agentC Trusted root certificate storeD Root certificate store

单选题Automatic data conversion will occur if which of the following happens?()AThe client and server have different NLS_LANGUAGE settings.BThe client and server character sets are not the same, and the database character set is not a strict superset of the client character set.CThe client and server are in different time zones.DThe client requests automatic data conversion.EThe AUTO_CONVERT initialization parameter is set to TRUE.