Free Oracle 1z1-908 Exam Dumps Questions & Answers


Exam Code/Number:	1z1-908Join the discussion
Exam Name:	MySQL 8.0 Database Administrator
Certification:	Oracle
Question Number:	142
Publish Date:	Jul 17, 2026
Rating 100%

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

A. Any instance can have multiple slaves, but it can have only one master.
B. Replication can use only TCP/IP connections.
C. Each slave must have its own MySQL user for replication.
D. Binary logging must be enabled on the master in order to replicate to other instances.
E. A replication user must have the SELECT privilege for all tables that need to be replicated.
F. Each instance in a replication topology must have a unique server ID.
G. Binary logs contain only transactions originating from a single MySQL instance.

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

Which statement is true about cold backups?

A. They are good to use when many users are online accessing the database.
B. They are backups taken from snapshots of a running database.
C. They are good to use if only data structures must be backed up but not log files.
D. They are backups taken from OS copy commands.

Which step or set of steps can be used to rotate the error log?

A. Execute SET GLOBAL log_error = '<new error log file>'.
B. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.
C. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.
D. Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.

How can mysql_multi be configured to allow MySQL instances to use the same port number?

Add Comments