网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?（）A.Activating the MySQL Enterprise thread pool pluginB.Relocating your data and log files to separate storage devicesC.Disconnecting idle localhost client sessionsD.Implementing storage engine data compression options
考题
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 started with the – enable–ssl-plugin optionC.— ssl is not a valid server optionD.The mysqld binary was not compiled with SSL supportE.The server‘s SSL certificate was invalid
考题
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 optionB.The audit_log.so library does not existC.The audit_log.so library is in a location that is different from that defined by the plugin_dir optionD.The audit plugin must be loaded dynamically by using the INSTALL PLUGIN commandE.The audit log file does not exist in which to write audit eventsF.The audit_log.so library is not an executable file
考题
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 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 configurationB.When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakesC.The mysqld_safe script skips the unknown variable and starts using the remaining configuration changesD.Mysqld prints to the error log about an unknown variable, and then exits
考题
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 validB.All of the MEDIUM password policy requirements have not been honoredC.The password matches a substring Hover as a dictionary wordD.The password does not match the validate_passoword_number_count requirementE.There is no dictionary file defined, so password validation cannot work as expected
考题
Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a connection event that has used external authentication?()
A.The attribute STATUS is set to the string EXTERNAL_AUTHB.The attribute PRIV_USER contains the usernameC.The event type that is given in the attribute NAME is EXTERNAL_AUTHD.There is no differentiation between native and external authentication eventsE.External authentication is managed through external auditing logsF.The PROXY_PRIV user shows a username if external authentication is used
考题
Consider the Mysql Enterprise Audit plugin. The following event detail is found in the audit log:Which two points can be concluded from the given event?()
A.A connection as the user kate was successfulB.A connection failed due to authentication being unsuccessfulC.A connection was attempted via socket rather than TCPD.A connection was blocked by a firewall or a similar security mechanismE.A connection failed because the proxy user privileges did not match the login user
考题
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements.You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( );Mysql＞ LOAD DATA INFILE ‘/tmp/data.cav‘ INTO TABLE mytable; Mysql＞ SHOW TABLES;How many events are added to the audit log as a result of the preceding statements?（）A.12; only top-level statements and stored procedure events are loggedB.111; top-level statements and all lower-level statements are loggedC.3; only the top-level statements are loggedD.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
考题
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）A、12; only top-level statements and stored procedure events are loggedB、111; top-level statements and all lower-level statements are loggedC、3; only the top-level statements are loggedD、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
考题
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 optionB、The audit_log.so library does not existC、The audit_log.so library is in a location that is different from that defined by the plugin_dir optionD、The audit plugin must be loaded dynamically by using the INSTALL PLUGIN commandE、The audit log file does not exist in which to write audit eventsF、The audit_log.so library is not an executable file
考题
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 configurationB、When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakesC、The mysqld_safe script skips the unknown variable and starts using the remaining configuration changesD、Mysqld prints to the error log about an unknown variable, and then exits
考题
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 fileB、An error message is issued because – install is not a valid option for mysqldC、A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnfD、Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file
考题
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 started with the – enable–ssl-plugin optionC、— ssl is not a valid server optionD、The mysqld binary was not compiled with SSL supportE、The server's SSL certificate was invalid
考题
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?（）A、Activating the MySQL Enterprise thread pool pluginB、Relocating your data and log files to separate storage devicesC、Disconnecting idle localhost client sessionsD、Implementing storage engine data compression options
考题
When you try to open your database， you receive the following error： ORA-00205： error in identifying control file Where would you find the details required to resolve this error？（）A、audit trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer
考题
Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a connection event that has used external authentication?（）A、The attribute "STATUS" is set to the string EXTERNAL_AUTHB、The attribute "PRIV_USER" contains the usernameC、The event type that is given in the attribute "NAME" is EXTERNAL_AUTHD、There is no differentiation between native and external authentication eventsE、External authentication is managed through external auditing logsF、The "PROXY_PRIV" user shows a username if external authentication is used
考题
When you try to open your database， you receive the following error： ORA-00205： error in identifying controlfile Where would you find the details required to resolve this error？（）A、audit trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer
考题
You are the administrator of a Windows 2000 Professional computer. You schedule a task to run after 15 minutes. One hour later， the task still has not run. You notice that your Event Viewer system log has the following error message； "The task scheduler service failed to start due to following error. The service did not start due to login failure." You want to run the scheduler task again. What should you do before restarting the task scheduler service？（）A、Set the task scheduler service to log on using the local system accountB、Set the task scheduler service to allow the service to interact with the desktopC、Restart the remote producer call （RPC） service.D、Log off and then log on to an account in the Power Users group.
考题
单选题Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）A
12; only top-level statements and stored procedure events are loggedB
111; top-level statements and all lower-level statements are loggedC
3; only the top-level statements are loggedD
102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
考题
单选题You are the administrator of a Windows 2000 Professional computer. You schedule a task to run after 15 minutes. One hour later， the task still has not run. You notice that your Event Viewer system log has the following error message； "The task scheduler service failed to start due to following error. The service did not start due to login failure." You want to run the scheduler task again. What should you do before restarting the task scheduler service？（）A
Set the task scheduler service to log on using the local system accountB
Set the task scheduler service to allow the service to interact with the desktopC
Restart the remote producer call （RPC） service.D
Log off and then log on to an account in the Power Users group.
考题
单选题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 fileB
An error message is issued because – install is not a valid option for mysqldC
A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnfD
Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file
考题
单选题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 validB
All of the MEDIUM password policy requirements have not been honoredC
The password matches a substring Hover as a dictionary wordD
The password does not match the validate_passoword_number_count requirementE
There is no dictionary file defined, so password validation cannot work as expected
考题
单选题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 configurationB
When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakesC
The mysqld_safe script skips the unknown variable and starts using the remaining configuration changesD
Mysqld prints to the error log about an unknown variable, and then exits
考题
单选题Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a connection event that has used external authentication?（）A
The attribute STATUS is set to the string EXTERNAL_AUTHB
The attribute PRIV_USER contains the usernameC
The event type that is given in the attribute NAME is EXTERNAL_AUTHD
There is no differentiation between native and external authentication eventsE
External authentication is managed through external auditing logsF
The PROXY_PRIV user shows a username if external authentication is used
考题
单选题While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?（）A
Activating the MySQL Enterprise thread pool pluginB
Relocating your data and log files to separate storage devicesC
Disconnecting idle localhost client sessionsD
Implementing storage engine data compression options
考题
单选题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 started with the – enable–ssl-plugin optionC
— ssl is not a valid server optionD
The mysqld binary was not compiled with SSL supportE
The server's SSL certificate was invalid
热门标签
最新试卷
