Note! Following 1z0-883 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-883 Exam Dumps - MySQL 5.6 Database Administrator

Go to page:

Question # 9

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

Which three HA solutions do not use shared storage?

Mysql Replication

Distributed Replicated Block Device (DRBD) and Mysql

Windows Cluster and Mysql

Solaris Cluster and Mysql

Mysql NDB Cluster

Full Access

Question # 10

What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?

Mysql Enterprise Backup

Mysqldump with â€“ binary-data option

Mysqlhotcopy

File system snapshots

Mysqldumpslow

Full Access

Question # 11

Which query would you use to find connections that are in the same state for longer than 180 seconds?

SHOW FULL PROCESSLIST WHEER Time > 180;

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

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

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;

Full Access

Question # 12

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?

FORCE_PLUS_PERMANENT is not valid for the audit-log option.

The audit_log.so library does not exist.

The audit_log.so library is in a location that is different from that defined by the plugin_dir option.

The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.

The audit log file does not exist in which to write audit events.

The audit_log.so library is not an executable file.

Full Access

Question # 13

A MySQL replication slave is set up as follows:

User all InnoDB tables
Receives ROW-based binary logs
Has the read-only option

The replication slave has been found in an error state.

You check the MySQL error log file and find the following entries:

2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry â€˜3â€™ for keyâ€™PRIMARYâ€™ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the eventâ€™s master log 56_master-bin.000003, end_log_pas 653,

Error_code: 1062

2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry â€˜3â€™ for key â€˜PRIMARYâ€™

Error_code: 1062

2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with â€œSLAVE STARTâ€, We stopped at log â€˜56_master-bin.000003â€™ position 496

What are two possible causes for this error to occur?

The slave was created with mysqldump â€“u root â€“p â€“ skip-lock-tableâ€”all-databases > /data/data.sql

The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function.

For tables with UNIQUE keys, statement-based replication must be used maintain integrity.

The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

The applications have the SUPER privilege, which allows them to update rows.

Full Access

Question # 14

The validate_password plugin is loaded and displays the following settings in global variables:

Mysql> SHOW VARIABLES LIKE â€˜validate_password%â€™;

When attempting to set your password, you get the following error:

Mysql> SET PASSWORD = PASSWORD (â€˜Hoverl@%â€™);

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

What is the cause of the error?

The password is eight characters long, but needs to exceed validate_password_length to be valid.

All of the MEDIUM password policy requirements have not been honored.

The password matches a substring Hover as a dictionary word.

The password does not match the validate_passoword_number_count requirement.

There is no dictionary file defined, so password validation cannot work as expected.

Full Access

Question # 15

ROW-based replication has stopped working. You investigate the error log file and find the following entries:

2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Canâ€™t find record in â€˜t1â€™, Error_code: 1032; handler error

HA_ERR_KEY_NOT_FOUND; the eventâ€™s master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032

2013-08-27 14:15:47 9056 [warning] Slave: Canâ€™t find record in â€˜t1â€™ Error_code: 1032

2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with â€œSLAVE STARTâ€. We stopped at log â€˜56_master-bin. 000003â€™ position 684

Why did you receive this error?

The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s

The table definition on the slave -litters from the master.

Multi-threaded replication slaves can have temporary errors occurring for cross database updates.

The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist.

Full Access

Go to page: