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

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

2.MySQL is installed on a Linux server and has the following configuration:What is the purpose of changing ownership of datadir to the ‘mysql’ user?()A.MySQL requires correct file ownership while remaining secureB.MySQL needs to be run as the root user, but file cannot be owned by itC.MySQL cannot be run as the root user

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

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 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. 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”相关问题

  • 第1题：

    In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（）Mysql＞ SELECT * INTO OUTFILE ‘/tmp/t1.sql‘ from t1;mysql＞ TRUNCATE t1;

    A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql

    B.Mysql＞ INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql‘

    C.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql

    D.Mysql＞ LOAD DATA INFILE ‘/tmp/t1.sql‘ INTO TABLE t1

    E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql


    参考答案：D, E

  • 第2题：

    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

  • 第3题：

    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 file

    B.An error message is issued because – install is not a valid option for mysqld

    C.A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf

    D.Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file


    参考答案：A

  • 第4题：

    在mysql中如何插入图片数据：（ ）。

    A.mysql支持图片格式

    B.存储图片的路径

    C.无法插入

    D.使用load_file函数存储


    正确答案：BD

  • 第5题：

    In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;

    • A、$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
    • B、Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
    • C、$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql
    • D、Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
    • E、$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

    正确答案:D,E

  • 第6题：

    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

  • 第7题：

    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

  • 第8题：

    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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    MySQL is installed on a Linux server and has the following configuration: What is the purpose of changing ownership of datadir to the ‘mysql’ user?（）
    A

    MySQL requires correct file ownership while remaining secure

    B

    MySQL needs to be run as the root user, but file cannot be owned by it

    C

    MySQL cannot be run as the root user


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

  • 第11题：

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

    B

    An error message is issued because – install is not a valid option for mysqld

    C

    A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnf

    D

    Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file


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

  • 第12题：

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


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

  • 第13题：

    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

  • 第14题：

    Consider the query:Mysql＞ SET @run = 15;Mysql＞ EXPLAIN SELECT objective, stage, COUNT (stage)FROM iteminformationWHERE run=@run AND objective=’7.1’GROUP BY objective,stageORDER BY stage;The iteminformation table has the following indexes;Mysql＞ SHOW INDEXES FROM iteminformation:This query is run several times in an application with different values in the WHERE clause in a growing data set.What is the primary improvement that can be made for this scenario?（）

    A.Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes

    B.Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations

    C.Drop the run_2 index because it has caused a conflict in the choice of key for this query

    D.Execute the run_2 index because it has caused a conflict in the choice of key for this query

    E.Add a composite index on (run,objective,stage) to allow the query to fully utilize an index


    参考答案：E

  • 第15题：

    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

  • 第16题：

    在MySQL中如何插入图片数据？（）

    • A、无法插入
    • B、MySQL支持图片格式
    • C、存储图片的路径
    • D、使用load_file函数存储

    正确答案:C,D

  • 第17题：

    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

  • 第18题：

    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 file
    • B、An error message is issued because – install is not a valid option for mysqld
    • C、A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnf
    • D、Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file

    正确答案:A

  • 第19题：

    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

    正确答案:D

  • 第20题：

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


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

  • 第21题：

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


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

  • 第22题：

    多选题
    In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;
    A

    $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql

    B

    Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'

    C

    $ mysql – u root – p – h localhost test ＜ /tmp/t1.sql

    D

    Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1

    E

    $ mysqlinport – u root – p – h localhost test /tmp/t1.sql


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

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


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

  • 第24题：

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


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

相关内容