ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam
Go to Exam

Exam 1z0-908 topic 1 question 38 discussion

Actual exam question from Oracle's 1z0-908
Question #: 38
Topic #: 1
[All 1z0-908 Questions]

Which three statements are true about MySQL replication? (Choose three.)

  • A. Replication can use only TCP/IP connections.
  • B. Any instance can have multiple slaves, but it can have only one master.
  • C. Each instance in a replication topology must have a unique server ID.
  • D. Binary logs contain only transactions originating from a single MySQL instance.
  • E. Each slave must have its own MySQL user for replication.
  • F. Binary logging must be enabled on the master in order to replicate to other instances.
  • G. A replication user must have the SELECT privilege for all tables that need to be replicated.
Show Suggested Answer Hide Answer
Suggested Answer: CFG 🗳️
by FelipeK at Oct. 15, 2023, 6:42 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
marklv
9 months, 3 weeks ago
ACF G IS NOT RIGHT. The slave does not need to be able to select data. It just needs to be able to get to the binlog and download commands.
upvoted 1 times
marklv
7 months, 4 weeks ago
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html "Note Replication cannot use Unix socket files. You must be able to connect to the replication source server using TCP/IP." For replication, you just need to be able read the binlogs. You do not need access to the tables on the master, so G is not it. A is.
upvoted 2 times
...
...
FelipeK
9 months, 3 weeks ago
Selected Answer: CFG
C. Each instance in a replication topology must have a unique server ID. This is important to ensure that each instance can be uniquely identified in the replication process. F. Binary logging must be enabled on the master in order to replicate to other instances. Binary logging is essential for the master server to record changes that need to be replicated to the slave servers. G. A replication user must have the SELECT privilege for all tables that need to be replicated. The replication user on the slave server needs the SELECT privilege on the tables it's replicating to retrieve the data changes from the master.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago