单选题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 wi

题目
单选题
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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第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


参考答案:D

第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.


参考答案:A

第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.


参考答案:A

第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?()

  • A、Modify the IP address on Server3. 
  • B、Modify the IP address on Server1. 
  • C、Configure the hosts file on each server. 
  • D、Modify the default gateway for each server. 

正确答案:A

第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?()

  • 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

正确答案:B,E

第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


参考答案:A

第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.


参考答案:A

第8题:

You are attempting to secure a MySQL server by using SSL encryption.On starting MySQL, you get this error:130123 10:38:02 [ERROR] mysqld: unknown option ‘—ssl‘What is the cause of the error?()

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


参考答案:C

第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?()

  • A、FORCE_PLUS_PERMANENT is not valid for the audit-log option
  • B、The audit_log.so library does not exist
  • C、The audit_log.so library is in a location that is different from that defined by the plugin_dir option
  • D、The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command
  • E、The audit log file does not exist in which to write audit events
  • F、The audit_log.so library is not an executable file

正确答案:B,C

第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?()

  • 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

正确答案:D

更多相关问题