Oracle MySQL 2019 Implementation Essentials - 1Z1-920 Exam Questions [2026]

QUESTION NO: 1
Which two statements are correct about MySQL Enterprise Edition?

A. Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II). B. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network. C. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances. D. MySQL configuration can be changed in /etc/lib/myi.cnf. E. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

Correct Answer: A,D

QUESTION NO: 2
You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

A. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file. B. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup. C. Use mysqldump with the - -changesonly option. D. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression. E. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

Correct Answer: C,D

QUESTION NO: 3
The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

A. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days. B. To safely purge binary log files, perform these steps:
1. On each slave server, use show slave status to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with show binary logs.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up-to-date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file by using the purge binary logs statement C. Delete all binlog files manually on the file system to release storage spaces. D. On the Master server, disable binlog by removing the --log-bin option. E. Execute the purge binary logs statement without argument.

Correct Answer: A,B

QUESTION NO: 4
Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

A. MySQL Router to ensure client requests are load balanced and routed to the correct servers. B. MySQL Servers with Group Replication to replicate data to all members of the cluster. C. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication. D. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI. E. MySQL Online Hot Backup to keep data consistent and always ready to be used.

Correct Answer: A,B,D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

A. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances. B. Go to the configuration section (MEM) and configure the default login credentials. C. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances. D. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

Correct Answer: C

QUESTION NO: 6
Which two statements are true about MySQL Enterprise Authentication?

A. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies. B. MySQL Enterprise Authentication determines what operation the user can perform. C. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM). D. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords.. E. MySQL Enterprise Authentication supports Windows Active Directory.

Correct Answer: C,E

QUESTION NO: 7
The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?
A)

B)

C)

D)

A. Option A B. Option C C. Option D D. Option B

Correct Answer: A