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

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

Exam Questions: 78
Updated On: Aug 05, 2026

Question #1

Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:

A. MySQL Query Analyzer

B. MySQL Dashboard

C. Query Analyzer

D. MySQL Advisors

Discussion 0

Correct Answer: A Vote an answer

Question #2

You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving--hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.

B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.

D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.

Discussion 0

Correct Answer: B Vote an answer

Question #3

Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

A. connections through the local host via the UNIX socket file

B. SECURID authentication and authorization identity

C. Native Windows services

D. authentication via Pluggable Authentication Modules (PAMs)

E. authentication using SHA-256 password hashing

F. Simple Authentication and Security Layer

Discussion 0

Correct Answer: A,C,D,E Vote an answer

Question #4

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

Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

A. MySQL Audit and MySQL Workbench

B. SQL Enterprise Monitor and MySQL Enterprise Authentication

C. MySQL Enterprise Monitor and MySQL Audit

D. MySQL Workbench and MySQL Enterprise Firewall

Discussion 0

Correct Answer: B Vote an answer

Question #6

Which of the following statements is true regarding MySQL user account privileges?
Response:

A. The USAGE privilege allows a user to connect to the MySQL server but grants no other privileges.

B. The GRANT option allows a user to revoke privileges from other users.

C. The RELOAD privilege allows a user to delete data from a table.

D. A user with the SUPER privilege can only read data from the database.

Discussion 0

Correct Answer: A Vote an answer

Question #7

You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

A. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

B. You can expect an outage of your MySQL OCI instance during the planned time..

C. You need to agree to the maintenance windows. If not, you are not affected by the outage.

D. There are no maintenance operations planned. You need to do them manually.

Discussion 0

Correct Answer: B Vote an answer

Question #8

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

Download Free Oracle 1Z1-921 Demo

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