1Z0-888 Exam Dumps | A MySQL replication slave is set up as follows: Uses all InnoDB tables (Exhibit) Receives ROW-based binary

<< Prev Question Next Question >>

A MySQL replication slave is set up as follows:
Uses 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 these entries:

What are two possible causes for this error to occur? (Choose two.)

A. The applications have the SUPERprivilege, which allows them to update rows.

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

C. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases
> /data/data.sql

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

E. The slave user does not have INSERT, UPDATE, or DELETEpermission and cannot execute the Write_rowsfunction.

Download PDF File