Download Oracle.1z0-883.PracticeTest.2018-08-09.58q.tqb

Vendor:	Oracle
Exam Code:	1z0-883
Exam Name:	MySQL 5.6 Database Administrator
Date:	Aug 09, 2018
File Size:	601 KB

Download Exam

Demo Questions

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?

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

Correct answer: B

Consider the events_% tables in performance Schema.

Which two methods will clear or reset the collected events in the tables?

Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current;
Using the statement RESET PERFORMANCE CACHE;
Using the statement FLUSH PERFORMANCE CACHE;
Using TRUNCATE statements, for example, TRUNCATE TABLE performance_schema.events_waits_current;
Disabling and re-enabling all instruments
Restarting Mysql

Correct answer: DE

Explanation:

D: To avoid unpredictable results if you make timer changes, use TRUNCATE TABLE to reset Performance Schema statistics.Example:As with other aggregate tables within Performance Schema, you can reset the statistics within the digest table with:TRUNCATE TABLE performance_schema.events_statements_summary_by_digest; Reference: 22.2.3.1 Performance Schema Event Timinghttp://dev.mysql.com/doc/refman/5.5/en/performance-schema-timing.html

D: To avoid unpredictable results if you make timer changes, use TRUNCATE TABLE to reset Performance Schema statistics.

Example:

As with other aggregate tables within Performance Schema, you can reset the statistics within the digest table with:

TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;

Reference: 22.2.3.1 Performance Schema Event Timing

http://dev.mysql.com/doc/refman/5.5/en/performance-schema-timing.html

What are four capabilities of the mysql client program?