多选题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?()AFORCE_PLUS_PERMANENT is not valid for the audit-log optionBThe audit_log.so library does not existCThe audit_log.so library is in a location that is different from that defined by the plugin_dir optionDThe audit plugin must be loaded dynamically by using the INSTALL PLUGIN commandEThe audit log file does not exist in which to write audit eventsFThe audit_log.so library is not an executable file

多选题
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


参考解析

解析: 暂无解析

相关考题:

You are developing a Windows Communication Foundation (WCF) service. The service configuration file has a element defined. You need to ensure that all security audit information, trace logging, and message logging failures are recorded.Which configuration segment should you add to the element?()A.B.C.D.

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

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

The following commands are available in the Linux binary distributions of Mysql: Mysqld Mysqld_safe Mysql.server What is the correct description of each of these commands?() A.AB.BC.CD.D

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

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

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

You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tail – n2 /var/lib.mysql/hostname.err 2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: '5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock' port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) You attempt to log in as the root user with the following command: $mysql – u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Which statement is true about this scenario?()A、The RPM installation script sets a default password of password for new installationsB、The local root user must log in with a blank password initially: mysql –u root –pC、New security measures mean that the mysql_secure_installation script must be run first on all new installationsD、The mysql_install_bd post-installation script used – random-password

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

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

You use Windows 2000 Professional on your desktop Computer. You schedule a task to run an MMC snap-in to perform configuration tasks on other computers. You notice that the task is not completing correctly. You manually start MMC. You add the snap-in. You are then able to successfully run the task. You verify that all of your other tasks are working correctly. You want to enable your tasks to complete successfully. What should you do?()A、Use Scheduled Tasks to configure the task to run under the security context of your account.B、Configure the Task Scheduler service account to use a local Administrator account and password.C、Use Computer Management to start the Messenger service and to configure the Messenger service to start automatically. D、Use Computer Management to start the Task Scheduler service and to configure the Task Scheduler service to start automatically.

A service fails to start. Which of the following places can a technician go to find the services console?()A、System configuration utilityB、Device ManagementC、Task ManagerD、Computer Management

多选题Shortly after the Press Ctrl-Alt-Delete to login screen appears in Windows XP, a user gets the error One or more services failed to start. Which of the following locations could be accessed to identify the service that did not start and attempt to start the service manually?()AComputer ManagementBServices MMC Plug-inCEvent LogDTask ManagerESystem Configuration Utility

多选题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?()AFORCE_PLUS_PERMANENT is not valid for the audit-log optionBThe audit_log.so library does not existCThe audit_log.so library is in a location that is different from that defined by the plugin_dir optionDThe audit plugin must be loaded dynamically by using the INSTALL PLUGIN commandEThe audit log file does not exist in which to write audit eventsFThe audit_log.so library is not an executable file

多选题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?()AFORCE_PLUS_PERMANENT is not valid for the audit-log optionBThe audit_log.so library does not existCThe audit_log.so library is in a location that is different from that defined by the plugin_dir optionDThe audit plugin must be loaded dynamically by using the INSTALL PLUGIN commandEThe audit log file does not exist in which to write audit eventsFThe audit_log.so library is not an executable file

单选题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?()AMysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration fileBAn error message is issued because – install is not a valid option for mysqldCA running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnfDMysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration 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?()AMysqld uses internal configuration versioning and reverts to the previous configurationBWhen using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakesCThe mysqld_safe script skips the unknown variable and starts using the remaining configuration changesDMysqld prints to the error log about an unknown variable, and then exits

多选题You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?()AShell> mysqladmin –u root –p shutdownBShell> nmc mysql shutdownCMysql> STOP PROCESS mysqldDShell> /etc/init.d/mysql stopEShell> service mysql safe_exitFShell> pkill –u mysql mysqld_safeGShell> net stop mysql

单选题The following commands are available in the Linux binary distributions of Mysql: Mysqld Mysqld_safe Mysql.server What is the correct description of each of these commands?()A AB BC CD D