1z0-883 試験問題を無料オンラインアクセス

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.The audit_log.so library is not an executable file.
• B.The audit_log.so library does not exist.
• C.FORCE_PLUS_PERMANENT is not valid for the audit-log option.
• D.The audit log file does not exist in which to write audit events.
• E.The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.
• F.The audit_log.so library is in a location that is different from that defined by the plugin_dir option.

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

You are using the performance Schema to investigate replication on a slave:
Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime
FROM performance_schema.events_waits_summary_by_thread_by_event_name
INNER JOIN performance_schema_threads USING (THREAD_ID)
WHERE threads .NAME LIKE 'thread/sql/slave\-%'
GROUP BY THREAD_ID, threads.NAME;

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?

• A.The slave cannot process the relay log fast enough to use all threads.
• B.The server needs more cores to use all slave threads.
• C.The slave is configured with slave_parallel_workers = 4.
• D.At most two schemas are being updated concurrently.

You use-login-path to access a MySQL server on a Linux installation.
Which statement is true about the - login-path option that is created by using mysql_config_editor?

• A.All system users have access to the MySQL server via-login path local.
• B.__login-path can be used only for MySQL servers running on a local machine.
• C.When using - login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later.
• D.__login-path allows you to provide login credentials without passing clear text passwords on the command line.

Which three are properties of the MyISAM storage engine?

• A.Transaction support
• B.FULLTEXT indexing for text matching
• C.Geospatial indexing
• D.Table level locking only
• E.Table and page level locking support
• F.HASH index support
• G.Foreign key support