CMS专题
单选题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 T
题目
The attribute STATUS is set to the string EXTERNAL_AUTH
The attribute PRIV_USER contains the username
The event type that is given in the attribute NAME is EXTERNAL_AUTH
There is no differentiation between native and external authentication events
External authentication is managed through external auditing logs
The PROXY_PRIV user shows a username if external authentication is used
参考答案和解析
相似问题和答案
第1题：
A.A connection as the user kate was successful
B.A connection failed due to authentication being unsuccessful
C.A connection was attempted via socket rather than TCP
D.A connection was blocked by a firewall or a similar security mechanism
E.A connection failed because the proxy user privileges did not match the login user
第2题：
A.Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B.Using the statement RESET PERFORMANCE CACHE
C.Using the statement FLUSH PERFORMANCE CACHE
D.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E.Disabling and re-enabling all instruments
F.Restarting Mysql
第3题：
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 plugin
B.Relocating your data and log files to separate storage devices
C.Disconnecting idle localhost client sessions
D.Implementing storage engine data compression options
第4题：
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 logged
- B、111; top-level statements and all lower-level statements are logged
- C、3; only the top-level statements are logged
- D、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
正确答案:C
第5题：
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 application
- B、to pre-populate user wallets with all their application credentials in one go
- C、to enhance out-of-the-box audit logging by creating custom audit log events
- D、to create reports from audit log trails collected by IBM Tivoli Access Manager for Enterprise Single Sign-On
- E、to configure automatic password change on expiry for an application so that the new password is a random string of specified strength
正确答案:A,B
第6题：
A.Mysql NDB Cluster
B.Mysql Replication
C.Distributed Replicated Block Device (DRBD) and Mysql
D.Windows Cluster and Mysql
E.Solaris Cluster and Mysql
第7题：
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.True
B.False
Where there is a significant change in ownership of the company, ISA 210 Agreeing the Terms of Audit Engagements recommends that a new audit engagement letter is sent to avoid misunderstandings.
第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题：
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.
正确答案:B
第10题：
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