Free Oracle 1Z0-920 Practice Test & Real Exam Questions

Exam Code/Number: 1Z0-920
Exam Name/Title: MySQL 2019 Implementation Essentials
Certification Provider: Oracle
Corresponding Certification: MySQL Cloud Service

Exam Questions: 70
Updated On: Aug 09, 2026

Question #1

What three are ways to export and import data in MySQL Workbench?

A. Data Modeling Import Export Wizard

B. Backup Data Export and Import Wizard

C. SQL Data Export and Import Wizard

D. Binary Data Export and Import Wizard

E. Table Data Export and Import Wizard

F. Result Data Export and Import

Discussion 0

Correct Answer: C,E,F Vote an answer

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

Question #2

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. On the Master server, disable binlog by removing the --log-bin option.

C. Execute the purge binary logs statement without argument.

D. Delete all binlog files manually on the file system to release storage spaces.

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

Discussion 0

Correct Answer: A,E Vote an answer

Question #3

Which three statements are true about MySQL Enterprise Backup?

A. It cannot back up encrypted tablespaces.

B. It enables you to take non-locking backups.

C. It performs logical backups.

D. It provides the ability to create incremental backups.

E. It performs hot or warm backups.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #4

You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

A. Use mysqldump to import data from the sakila_dummy database sample data set.

B. Execute the sakila-data. sqi script to populate the database

C. Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;

D. Use MySQL Enterprise High Availability to access one of the available data tables

Discussion 0

Correct Answer: C Vote an answer

Question #5

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

A. monitoring the availability of the MySQL Instance

B. deploying MySQL agent on supported target operating system

C. creating e-mail alerts and SNMP traps for MySQL warnings

D. analyzing executed MySQL queries

E. starting and stopping the MySQL instance

F. tracing import and export with mysqldump

Discussion 0

Correct Answer: B,C,F Vote an answer

Question #6

The user 'fwuser'@'localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?
A)

A. Option C

B. Option B

C. Option D

D. Option A

Discussion 0

Correct Answer: C Vote an answer

Question #7

Which three are levels in which MySQL Enterprise Monitor provides access control?

A. Specific data access: the rights to view specific types of potentially sensitive data

B. Asset visibility: the rights to access data collected from hosts or MySQL instances

C. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration

D. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services

E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent

Discussion 0

Correct Answer: A,B,C Vote an answer

Download Free Oracle 1Z0-920 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-920 exam.