Oracle Exam 1Z0-888 Topic 10 Question 79 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 79
Topic #: 10

[All 1Z0-888 Questions]

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.)

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

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

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

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

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

Show Suggested Answer

Suggested Answer: E

by Lashon at Oct 08, 2023, 08:57 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!