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

第1题：

第2题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

• A、Each extra column in the copy with more columns must not have a default value
• B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
• C、The slave database cannot have more columns than the master. Only the master database can have more columns
• D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
• E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

第3题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

第4题：

You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）

• A、–skip-networking, to prohibit access from remote locations
• B、–reset-grant-tables, to start the server with only the mysql database accessible
• C、–read-only,to set all data to read-only except for super users
• D、–old-passwords, to start Mysql to use the old password format while running without the grant tables

第5题：

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

第6题：

Your company has a single Active Directory domain named contoso.com. All servers in the domain run Windows Server 2008.  The DNS service is installed on two domain controllers named DC1 and DC2. Both DNS servers host Active DirectoryCintegrated zones that are configured to allow the most secure updates only. DC1 has Key Management Service （KMS） installed and activated.  You discover that the service locator records from the contoso.com zone hosted on DC1 and DC2 are missing.  You need to force registration of the KMS service locator records in the contoso.com zone. What should you do？（）

• A、Configure the contoso.com zone to accept non-secure updates.
• B、On DC1 at the command prompt， run the slmgr.vbs Crearm script.
• C、On DC1 at the command prompt， run the net stop sppsvc command， and then run the net start sppsvc command.
• D、On DC2 at the command prompt， run the net stop netlogon command， and then run the net start netlogon command.

第7题：

Which of the following actions will allow you to convert from Windows Server 2012 R2 Standard to Windows Server Datacenter， using the least administrative effort？（）

• A、You should run Setup from the installation media.
• B、You should run the Install-WindowsFeature cmdlet from the Windows PowerShell.
• C、You should run the dism /online /add-package command from an elevated command prompt.
• D、You should run the dism /online /enable-feature command from an elevated command Prompt.
• E、You should run the dism /online /set-edition command from an elevated command prompt.

第8题：

You have the Web Server （IIS） role installed on a server that runs Windows Server 2008.   You make changes to the configuration of an application named APP1. Users report that the application fails. You examine the event log and discover the following error message：  503 Service Unavailable.  You need to ensure that users are able to connect to APP1.  Which command should you run at the command prompt on the server？（）

• A、appcmd set config
• B、appcmd stop apppool
• C、appcmd start apppool
• D、appcmd set apppool

第9题：

第10题：

第11题：

第12题：

第13题：

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）

• A、Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
• B、Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
• C、Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
• D、Set binlog_format=MIXED with the – replicate-ignore-temp-table option
• E、Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table

第14题：

Which command do you use to go from the shell prompt to the CLI prompt?（）

• A、run cli
• B、cli
• C、start cli
• D、edit

第15题：

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、STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383
• B、STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383
• C、STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE
• D、STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE

第16题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

• A、 Start the database in the MOUNT stage.
• B、 Back up the control file to trace.
• C、 Set the DBID
• D、 Issue the RECOVER DATABASE command.

第17题：

You need to force a domain controller to register all service location （SRV） resource records in  DNS.     Which command should you run（）

• A、ipconfig.exe /registerdns
• B、net.exe stop dnscache & net.exe start dnscache
• C、net.exe stop netlogon & net.exe start netlogon
• D、regsvr32.exe dnsrslvr.dll

第18题：

You receive a support call from a user complaining that every time she sends a print job to a printer, she receives a confirmation message telling her that the print job has been completed. She asks you whether it can be disabled. How can you configure this?（）

• A、You cannot configure such an option. 
• B、Stop the Alerter service under services in the control panel. 
• C、At the command line prompt type ‘ net stop messenger service’. 
• D、At the command line prompt type ‘ping messenger service’. 
• E、Uncheck the box “Notify when remote documents are printed” from the advanced server properties of the printer.

第19题：

You need to provide an administrator the ability to view and interact with your current logon session. What should you do?（）

• A、At the command prompt， run Psr.exe.
• B、At the command prompt， run Winrm.exe quickconfig.
• C、From the Start menu， open Remote Desktop Connection.
• D、From the Start menu， open Windows Remote Assistance.

第20题：

第21题：

第22题：

第23题：

第24题：