New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 11 Topic 2 Discussion

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 11 Topic 2 Discussion

1z0-908 Exam Topic 2 Question 11 Discussion:
Question #: 11
Topic #: 2

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.


Get Premium 1z0-908 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.