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

Exam Code/Number: 1Z0-921
Exam Name/Title: MySQL 2021 Implementation Essentials
Certification Provider: Oracle
Corresponding Certification: Oracle MySQL

Exam Questions: 78
Updated On: Aug 12, 2026

Question #1

Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

A. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

B. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

C. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database

D. A browser-based wizard to remotely deploy the MySQL Monitor Agent

E. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #2

Which three are characteristics of the JSON data type?

A. It is based on the TEXT data type.

B. It supports indexing directly against the JSON-defined column.

C. It validates the JSON syntax on insert or merge.

D. A set of SQL functions substantially support the SQL utilization of the data type.

E. Key or array references enable quick read-access to look up document elements directly.

F. Comparisons of JSON values are not case-sensitive.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #3

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

Question #4

Which activity will take place if a table is created with both the compression and encryption options?

A. The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.

B. The tablespace data is encrypted first and then compression is performed.

C. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.

D. The compression is performed before tablespace data is encrypted.

Discussion 0

Correct Answer: D Vote an answer

Question #5

Which query will find rows in a table that have no counterpart in another table?

A. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;

B. SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;

C. SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;

D. SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;

Discussion 0

Correct Answer: C Vote an answer

Question #6

You need to change the password level for a test system.
Which two allow to change this level before you create new test user/passwords?

A. SET GLOBAL force_password_complex_policy=0;

B. Add validate_password_policy=,new level, in the [mysqld] section of the MySQL configuration file.

C. SET GLOBAL validate_password_policy=,new level,;

D. Add validate_password=,new level, in the [security] section of the MySQL configuration file.

Discussion 0

Correct Answer: B,C Vote an answer

Question #7

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 #8

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

A. It provides multi-master access where the application can write and read data across the database servers.

B. It allows backup to be done on the slave without impacting the master.

C. MySQL Enterprise Backup will back up from Slave automatically.

D. You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

E. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.

Discussion 0

Correct Answer: B,C,D Vote an answer

Download Free Oracle 1Z0-921 Demo

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