Mysqld uses internal configuration versioning and reverts to the previous configuration
When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes
The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes
Mysqld prints to the error log about an unknown variable, and then exits
第1题:
You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?()
A.Mysqld uses internal configuration versioning and reverts to the previous configuration
B.When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes
C.The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes
D.Mysqld prints to the error log about an unknown variable, and then exits
第2题:
You have a stand-alone server that runs Windows Server 2003 Service Pack 2 (SP2).You attempt to log on to the server by using the Administrator account and receive the following error message.You need to log on to the server by using the Administrator account.What should you do first? ()
A. Restart the server in Safe mode.
B. Restart the server by using the Last Known Good Configuration option.
C. Log on to another stand-alone server as an Administrator.
D. Log on to the server by using an account that is a member of the Power Users group.
第3题:
A Windows Communication Foundation (WCF) service is hosted in Microsoft Internet Information Services (IIS). You are preparing the configuration file for production deployment. You need to set up tracing so that an administrator can adjust the System.ServiceModel trace level without causing the ASP.NET host application domain to restart. You need to ensure that tracing is turned off by default.What should you do?()
A.
B.
C.
D.
第4题:
You install three servers that run Windows Server 2003 Service Pack 2 (SP2). The servers are on the same subnet.You get the IP configuration for the servers as shown in the following table. You need to ensure that you can establish communication between the three servers. What should you do?()
第5题:
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?()
第6题:
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.C: \> mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?()
A.Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file
B.An error message is issued because – install is not a valid option for mysqld
C.A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf
D.Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file
第7题:
You have a server that runs Windows Server 2003 Service Pack 2 (SP2) and is configured as a domaincontroller.You run Windows Update and install a number of device drivers.You restart the server. During the startup process, the server stops.You receive the following stop error message: 0x000000D1 (0x0000000c, 0x00000002, 0x00000000,0xf27b4e8e) IRQL_NOT_LESS_OR_EQUAL.”You need to identify which device or service is causing the error.What should you do? ()
A. Restart the server by using the Safe Mode option. Review the contents of the ntbtlog.txt file.
B. Restart the server by using the Last Known Good Configuration option. Review the spupdsvc.log file.
C. Restart the server by using the Directory Services Restore Mode option. Review the contents of the ntdtcsetup.log file.
D. Restart the server by using the Safe Mode with Networking option. Review the contents of the WindowsUpdate.log file.
第8题:
A.The — ssl level was not specified
B.The server was not started with the – enable–ssl-plugin option
C.— ssl is not a valid server option
D.The mysqld binary was not compiled with SSL support
E.The server‘s SSL certificate was invalid
第9题:
Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why the service did not start?()
第10题:
You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?()