Oracle 1Z0-920 Actual Free Exam Questions & Community Discussion

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: Jun 22, 2026

Question #8

Which three prerequisites are needed for creating an Oracle Linux VM instance in the Oracle Cloud Infrastructure?

A. subnet configured on a Virtual Cloud Network (VCN)

B. Object Storage

C. Custom Image

D. ssh key pair

E. bare metal Oracle Linux shape

F. existing VCN

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #9

What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

A. Direct support call from an Oracle representative

B. Application-to-application messaging

C. Email

D. SMS-notification tab on the dashboard

E. Browser pop-ups

Discussion 0

Correct Answer: C,D Vote an answer

Question #10

Which three statements describe MySQL Enterprise Backup?

A. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

B. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

C. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.

D. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.

E. MySQL Enterprise Backup provides the point-in-time recovery functionality.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #11

Which is true about inserting an additional line in a single document stored in MySQL document store?

A. You cannot insert a single line, you have to replace the entire document with a new document.

B. Any new lines can only be inserted at the end of the document.

C. You specify the new element's position in the JSON_ARRAY_INSERT statement.

D. The path specified must be an array position past the end of an array using the JSON_POSITION statement.

Discussion 0

Correct Answer: C Vote an answer

Question #12

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 (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

B. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.

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 (MEM) and configure the default login credentials.

Discussion 0

Correct Answer: C Vote an answer

Question #13

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

A. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.

B. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.

C. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.

D. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.

Discussion 0

Correct Answer: B Vote an answer

Question #14

What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. Encryption key is stored in a centralized key memory location

B. Tablespace keys are managed manually behind the scenes.

C. Enables data-at-rest encryption by encrypting the physical files of the database.

D. Data is encrypted automatically, in real time, after it is written to storage.

Discussion 0

Correct Answer: 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.