1z0-883
单选题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 specifiedB The server was not s
题目
The — ssl level was not specified
The server was not started with the – enable–ssl-plugin option
— ssl is not a valid server option
The mysqld binary was not compiled with SSL support
The server's SSL certificate was invalid
参考答案和解析
相似问题和答案
第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 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
第3题：
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
第4题：
What are three methods to reduce Mysql server exposure to remote connections?（）
- A、Setting — skip-networking when remote connections are not required
- B、Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications
- C、Setting specific GRANT privilege to limit remote authentication
- D、Setting – mysql_secure_configuration to enable paranoid mode
- E、Using SSL when transporting data over remote networks
正确答案:A,C,E
第5题：
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
第6题：
The validate_password plugin is loaded and displays the following settings in global variables: Mysql＞ SHOW VARIABLES LIKE ‘validate_password%’;When attempting to set your password, you get the following error: Mysql＞ SET PASSWORD = PASSWORD (‘Hoverl@%’);ERROR 1819 (HY000): Your password does not satisfy the current policy requirements What is the cause of the error?（）
A.The password is eight characters long, but needs to exceed validate_password_length to be valid
B.All of the MEDIUM password policy requirements have not been honored
C.The password matches a substring Hover as a dictionary word
D.The password does not match the validate_passoword_number_count requirement
E.There is no dictionary file defined, so password validation cannot work as expected
第7题：
You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers，configuring Windows Server 2008 Terminal services and network application services，and configuring aweb services infrastructure. There is an Active Directory domain in your company. The company has aserver which is named S01. S01 has the Terminal Services server role and the TS Web Access role service installed. The company has a server named S02 that runs ISA Server 2006. The company deploysthe Terminal Services Gateway （TS Gateway） role on a new server named S03. The company wants to useISA as the SSL endpoint for Terminal Server connections. You have to configure the TS Gateway role onS03 to use ISA 2006 on S02. What action should you perform？（）
- A、A self-signed SSL certificate should be exported from S03 and the SSL certificate should be installedon S02. The ISA service on S02 should be configured to use the SSL certificate from S03.
- B、The TS Gateway should be configured to use SSL HTTPS-HTTP bridging.
- C、The Terminal Services Connection Authorization Policy Store on S03 should be configured to use S02as the Central Network Policy Server.
- D、The SSL certificate should be exported from S02 and the SSL certificate should be installed on S03.The TS Gateway should be configured to use the SSL certificate from S02.
正确答案:B
第8题：
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 plugin
B.Execute the command FLUSH LOGS
C.Execute the command SET GLOBAL audit_log_fiush= ON
D.Move or rename the existing audit.log file
第9题：
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
第10题：
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