网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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_AUTH
B
The attribute PRIV_USER contains the username
C
The event type that is given in the attribute NAME is EXTERNAL_AUTH
D
There is no differentiation between native and external authentication events
E
External authentication is managed through external auditing logs
F
The PROXY_PRIV user shows a username if external authentication is used
参考答案
参考解析
解析：
暂无解析
更多 “单选题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
考题
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
考题
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 typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?()
A.Mysql NDB ClusterB.Mysql ReplicationC.Distributed Replicated Block Device (DRBD) and MysqlD.Windows Cluster and MysqlE.Solaris Cluster and Mysql
考题
Consider the events_% tables in performance Schema.Which two methods will clear or reset the collected events in the tables?()
A.Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_currentB.Using the statement RESET PERFORMANCE CACHEC.Using the statement FLUSH PERFORMANCE CACHED.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentE.Disabling and re-enabling all instrumentsF.Restarting Mysql
考题
Is the following statement true or false?A significant change in the ownership of an existing audit client is a factor which makes it appropriate for the auditor to review the terms of engagement.A.TrueB.False
考题
Which two situations necessitate integration of external systems with IBM Tivoli Access Manager for Enterprise Single Sign-On using API published by IBM Tivoli Access Manager for Enterprise Single Sign-On IMS Server？（）A、to add second factor based authentication to a Web applicationB、to pre-populate user wallets with all their application credentials in one goC、to enhance out-of-the-box audit logging by creating custom audit log eventsD、to create reports from audit log trails collected by IBM Tivoli Access Manager for Enterprise Single Sign-OnE、to configure automatic password change on expiry for an application so that the new password is a random string of specified strength
考题
To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）A、It contains only the plan for the SQL statement executed by the user.B、It contains the SQL text executed by the user and the bind variables used with it.C、It contains the plan and statistics associated with the SQL statement executed by the user.D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.
考题
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
考题
Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）A、Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_currentB、Using the statement RESET PERFORMANCE CACHEC、Using the statement FLUSH PERFORMANCE CACHED、Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentE、Disabling and re-enabling all instrumentsF、Restarting Mysql
考题
You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system （OS） file.D、It is a Recovery Manager （RMAN） script
考题
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
考题
Which statement is true about the log-output variable?（）A、It is a static variable and can be set only at MySQL server startupB、It enables and starts the General Query LogC、It sets the target location for the binary logs generated by the MySQL severD、It specifies output destinations for the slow and General Query logs
考题
多选题Which two software components are prerequisite products for the Common Audit and Reporting Service (CARS) event server?（）AIBM DB2 ServerBCrystal Enterprise ServerCIBM Tivoli Directory ServerDIBM WebSphere Application ServerEIBM Tivoli Access Manager Authorization Server
考题
单选题To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）A
It contains only the plan for the SQL statement executed by the user.B
It contains the SQL text executed by the user and the bind variables used with it.C
It contains the plan and statistics associated with the SQL statement executed by the user.D
It contains the plan for the SQL statement executed by the user and the bind variables used with it.
考题
多选题Which two situations necessitate integration of external systems with IBM Tivoli Access Manager for Enterprise Single Sign-On using API published by IBM Tivoli Access Manager for Enterprise Single Sign-On IMS Server？（）Ato add second factor based authentication to a Web applicationBto pre-populate user wallets with all their application credentials in one goCto enhance out-of-the-box audit logging by creating custom audit log eventsDto create reports from audit log trails collected by IBM Tivoli Access Manager for Enterprise Single Sign-OnEto configure automatic password change on expiry for an application so that the new password is a random string of specified strength
考题
单选题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
考题
单选题To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）A
It contains only the plan for the SQL statement executed by the user.B
It contains the SQL text executed by the user and the bind variables used with it.C
It contains the plan and statistics associated with the SQL statement executed by the user.D
It contains the plan for the SQL statement executed by the user and the bind variables used with it
考题
多选题Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）AUsing DELETE statements, for example, DELETE FROM performance_schema.events_watis_currentBUsing the statement RESET PERFORMANCE CACHECUsing the statement FLUSH PERFORMANCE CACHEDUsing TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentEDisabling and re-enabling all instrumentsFRestarting Mysql
考题
单选题Which statement is true about the log-output variable?（）A
It is a static variable and can be set only at MySQL server startupB
It enables and starts the General Query LogC
It sets the target location for the binary logs generated by the MySQL severD
It specifies output destinations for the slow and General Query logs
考题
多选题Which three statements are true regarding the fine-grained auditing （FGA）？（）AFGA is possible on SELECT statements only.BThe audit trail for FGA is stored in the FGA_LOG$ table.CThe audit trail for FGA is stored in the AUD_LOG$ table.DFGA enables a SQL predicate to define when to audit an event.EFGA audits DELETE statements only when audit columns are specified.FFGA includes the SQL statement used by the user as part of the audit event entry.
考题
多选题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. 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 typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?（）AMysql NDB ClusterBMysql ReplicationCDistributed Replicated Block Device (DRBD) and MysqlDWindows Cluster and MysqlESolaris Cluster and Mysql
考题
单选题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 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
热门标签
最新试卷
