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

<< Prev Question Next Question >>

Question 3/15

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 SUPER privilege, which allows them to update rows.

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

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

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

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

Question 3/15

LEAVE A REPLY

Download PDF File