单选题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 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 valueB.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.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 serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

查看答案

考题 Consider the MySQL Enterprise Audit plugin.On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error.In the audit log file, you notice the final entry:…What action should you take to fix the error and allow the service to start?（）A.Re-install the audit pluginB.Execute the command FLUSH LOGSC.Execute the command SET GLOBAL audit_log_fiush= OND.Move or rename the existing audit.log file

查看答案

考题 You have forgotten the root user account password. You decide to reset the password and execute the following:Shell＞ /etc/init.d/mysql stopShell＞ /etc/init.d/mysql start – skip-grant tablesWhich additional argument makes this operation safer?（）A.–skip-networking, to prohibit access from remote locationsB.–reset-grant-tables, to start the server with only the mysql database accessibleC.–read-only,to set all data to read-only except for super usersD.–old-passwords, to start Mysql to use the old password format while running without the grant tables

查看答案

考题 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

查看答案

考题 Which command do you use to go from the shell prompt to the CLI prompt?() A. run cliB. cliC. start cliD. edit

查看答案

考题 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_INVENTORYB、Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY tableC、Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary tableD、Set binlog_format=MIXED with the – replicate-ignore-temp-table optionE、Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table

查看答案

考题 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 valueB、Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC、The slave database cannot have more columns than the master. Only the master database can have more columnsD、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 serverE、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

查看答案

考题 Which command do you use to go from the shell prompt to the CLI prompt?（）A、run cliB、cliC、start cliD、edit

查看答案

考题 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 datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

查看答案

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

查看答案

考题 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 locationsB、–reset-grant-tables, to start the server with only the mysql database accessibleC、–read-only,to set all data to read-only except for super usersD、–old-passwords, to start Mysql to use the old password format while running without the grant tables

查看答案

考题 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： RMANBACKUP 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 DBIDD、 Issue the RECOVER DATABASE command.

查看答案

考题 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 need to force a domain controller to register all service location （SRV） resource records in DNS. Which command should you run（）A、ipconfig.exe /registerdnsB、net.exe stop dnscache net.exe start dnscacheC、net.exe stop netlogon net.exe start netlogonD、regsvr32.exe dnsrslvr.dll

查看答案

考题 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.

查看答案

考题 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.

查看答案

考题 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.

查看答案

考题 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.

查看答案

考题 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 configB、appcmd stop apppoolC、appcmd start apppoolD、appcmd set apppool

查看答案

考题单选题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： RMANBACKUP 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 DBIDD Issue the RECOVER DATABASE command.

查看答案

考题多选题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？（）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block

查看答案

考题单选题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 locationsB –reset-grant-tables, to start the server with only the mysql database accessibleC –read-only,to set all data to read-only except for super usersD –old-passwords, to start Mysql to use the old password format while running without the grant tables

查看答案

考题单选题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 locationsB –reset-grant-tables, to start the server with only the mysql database accessibleC –read-only,to set all data to read-only except for super usersD –old-passwords, to start Mysql to use the old password format while running without the grant tables

查看答案

考题单选题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= 1383B STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383C STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVED STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE

查看答案

考题单选题Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?（）A Re-install the audit pluginB Execute the command FLUSH LOGSC Execute the command SET GLOBAL audit_log_fiush= OND Move or rename the existing audit.log file

查看答案

考题单选题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 need to force a domain controller to register all service location （SRV） resource records in DNS. Which command should you run（）A ipconfig.exe /registerdnsB net.exe stop dnscache net.exe start dnscacheC net.exe stop netlogon net.exe start netlogonD regsvr32.exe dnsrslvr.dll

查看答案

考题单选题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 configB appcmd stop apppoolC appcmd start apppoolD appcmd set apppool

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：