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 D

题目

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
相似考题

1.MySQL数据库产品包括()A、MySQL企业服务器B、MySQL社区服务器C、MySQL嵌入数据库D、MySQL集群

2.修改MySQL用户root的密码的指令是?()A.mysqladmin-urootpasswordtestB.mysql-urootpasswordtestC.mysql-uroot-ptestD.mysql-uroot-passwordtest

3.取得查询语句的结果集合的记录总数的函数是:()。A.mysql_fetch_rowB.mysql_rowidC.mysql_num_rowsD.mysql_fetch_array

4.关于mysql_fetch_object说法中,正确的是:()。A.mysql_fetch_object和mysql_fetch_array一样，没什么区别B.mysql_fetch_object返回值是个对象，所以在速度上比mysql_fetch_array要慢C.mysql_fetch_object返回值是个数组，所以在速度上和mysql_fetch_array及mysql_fetch_row差不多D.mysql_fetch_object返回值是个对象，在速度上和mysql_fetch_array及mysql_fetch_row差不多

更多“Consider the Mysql Enterprise A”相关问题

  • 第1题：

    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


    参考答案：C

  • 第2题：

    Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?()

    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


    参考答案：A, B, C

  • 第3题：

    php连接上mysql之后,采用哪个函数配置循环可以得到指定表中的记录?()

    A.mysql_fetch_row

    B.mysql_select_db

    C.mysql_query

    D.mysql_connect


    参考答案：A

  • 第4题：

    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

  • 第5题：

    取得查询语句的结果集中的记录函数有（）

    • A、mysql_fetch_row
    • B、mysql_fetch_assoc
    • C、mysql_num_rows
    • D、mysql_fetch_array
    • E、mysql_fetch_object

    正确答案:A,B,D,E

  • 第6题：

    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

    正确答案:E

  • 第7题：

    You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.Company.com has merged with another company.The users at Company.com have complained that they are not able to share contacts with the users in the merge company.However， they can share free/busy information.The users at Company.com need to share contacts.What should you do？（）

    • A、You should consider changing the EWS virtual directory.
    • B、You should consider changing the Federation Trust.
    • C、You should consider changing the Organizational Relationship.
    • D、You should consider changing the default sharing policy.

    正确答案:D

  • 第8题：

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


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You are employed as the enterprise exchange administrator at Company.com..com makes use of Microsoft exchange server 2010 messaging solution.you are responsible for managing the exchange network for Company.com.you are experiencing various problems in the exchange environment.you decide to determine whether one of the other administrators executed any configuration changes in the organization.What should you do？（）
    A

    You should consider running Exchange Best Practices Analyzer.

    B

    You should consider running Microsoft Baseline Security Analyzer （MBSA）.

    C

    You should consider running the Get-ExchangeServer cmdlet.

    D

    You should consider running the Get-EventLogLevel cmdlet.


    正确答案： D
    解析： 暂无解析

  • 第10题：

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


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?（）
    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


    正确答案： B,C
    解析： 暂无解析

  • 第12题：

    单选题
    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 installations

    B

    The local root user must log in with a blank password initially: mysql –u root –p

    C

    New security measures mean that the mysql_secure_installation script must be run first on all new installations

    D

    The mysql_install_bd post-installation script used – random-password


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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 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


    参考答案：B, E

  • 第14题：

    PHP使用以下哪个函数连接MySQL数据库服务器()

    A.mysql_query

    B.mysql_select_db

    C.mysql_connect

    D.mysql_fetch_array


    参考答案：C

  • 第15题：

    php哪个函数用于向mysql数据库发送指令?()

    A.mysql_select_db

    B.mysql_connect

    C.mysql_query

    D.mysql_fetch_field


    参考答案：C

  • 第16题：

    php连接上mysql之后，采用哪个函数配置循环可以得到指定表中的记录？（）

    • A、mysql_fetch_row
    • B、mysql_select_db
    • C、mysql_query
    • D、mysql_connect

    正确答案:A

  • 第17题：

    如果想取得mysql数据库系统的运行状态，应该用什么函数？（）

    • A、mysql_ping
    • B、mysql_status
    • C、mysql_stat
    • D、mysql_info

    正确答案:C

  • 第18题：

    使用以下哪条指令能够实现数据库的长久连接？（）

    • A、mysql_connect
    • B、mysql_connectd
    • C、mysql_pconnetcd
    • D、mysql_pconnect

    正确答案:D

  • 第19题：

    You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.You have received instructions from the CIO to support Autodiscover from the Internet by creating a resource record in DNS.What should you do？（）

    • A、You should consider creating a Host （A） resource record.
    • B、You should consider creating a Text （TXT） resource record.
    • C、You should consider creating a Pointer （PTR） resource record.
    • D、You should consider creating a Mail exchange （MX） resource record.

    正确答案:A

  • 第20题：

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


    正确答案： B
    解析： 暂无解析

  • 第21题：

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


    正确答案： E,F
    解析： 暂无解析

  • 第22题：

    多选题
    What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）
    A

    File system snapshots

    B

    Mysqldumpslow

    C

    Mysqlhotcopy

    D

    Mysqldump with – binary-data option

    E

    Mysql Enterprise Backup


    正确答案： C,B
    解析： 暂无解析

  • 第23题：

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


    正确答案： A
    解析： 暂无解析

相关内容