Oracle MySQL 5.6 Database Administrator - 1z0-883 Free Exam Questions

A. SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB (NOW ( ), INTERVAL 180 SECOND) );

B. SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 180 SECOND) );

C. SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;

D. SHOW FULL PROCESSLIST WHEER Time > 180;

A. Partitioning allows easier management of smaller data sets for certain queries.

B. Partitioning is only available for those storage engines that implements it natively.

C. The partitioning expression is an integer or function that returns an integer value or NULL value.

D. Tables with BLOB and TEXT columns cannot be partitioned.

E. Partitioning allows different columns to be stored in separate files.

A. 102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.

B. 3; only the top-level statements are logged.

C. 111; top-level statements and all lower-level statements are logged.

D. 12; only top-level statements and stored procedure events are logged.

A. The overhead depends on the settings of the Performance Schema.

B. There is no impact on performance.

C. There is a constant overhead regardless of settings and workload.

D. There is an overhead for querying the Performance Schema but not for having it enabled.

A. Activating the MySQL Enterprise thread pool plugin

B. Relocating your data and log files to separate storage devices

C. Implementing storage engine data compression options

D. Disconnecting idle localhost client sessions

A. Execution of FULSH TABLES WITH READ LOCK

B. Starting of the I/O thread

C. Starting of the SQL thread

D. Reaching the slave_pendign _jobs_size_max limit

E. Execution of the FLUSH LOGS statement

A. Execute the command SET GLOBAL audit_log_fiush= ON.

B. Re-install the audit plugin.

C. Execute the command FLUSH LOGS.

D. Move or rename the existing audit.log file.

A. A connection was attempted via socket rather than TCP.

B. A connection failed because the proxy user privileges did not match the login user.

C. A connection as the user kate was successful.

D. A connection was blocked by a firewall or a similar security mechanism.

E. A connection failed due to authentication being unsuccessful.

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

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

C. Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file

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

A. Stop the server or lock the tables prior to the backup.

B. Make a copy of the .frm, .myd, and the .myi files.

C. Stop the server or lock the databases prior to the backup.

D. Always stop the server prior to the backup.

E. Make a copy of the binary log and tablespace files.