Oracle MySQL 2021 Implementation Essentials - 1Z0-921 Exam Questions [2026]

QUESTION NO: 1
Which MySQL command is used to grant specific privileges to a user on a database?
Response:

A. GRANT B. GIVE ACCESS C. GRANT PERMISSIONS D. SET PRIVILEGES

Correct Answer: A

QUESTION NO: 2
What are Security Lists in Oracle Cloud Infrastructure?

A. Security lists are data encryption levels that control who can see the data. B. They are essentially firewall rules that help control traffic between OCI instances. C. They allow administrators access to applications in the cloud and external servers. D. They contain rules established by HIPAA for securing end-user data. E. They are user-role designations that assign rights to certain internal users and external users.

Correct Answer: B

QUESTION NO: 3
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: 4
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: 5
What are the two main components required to set up persistent storage for MySQL on Kubernetes?
Response:

A. Pod and ReplicaSet B. PVC (Persistent Volume Claim) and ConfigMap C. PVC (Persistent Volume Claim) and PV (Persistent Volume) D. Secret and Deployment

Correct Answer: C

QUESTION NO: 6
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.

Correct Answer: C

QUESTION NO: 7
What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. Encryption key is stored in a centralized key memory location B. Enables data-at-rest encryption by encrypting the physical files of the database. C. Tablespace keys are managed manually behind the scenes. D. Data is encrypted automatically, in real time, after it is written to storage.

Correct Answer: B

QUESTION NO: 8
You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

A. --decompress B. --uncompress-and-apply-log C. --apply-log-and-copy-back D. --copy-back-and-apply-log E. --uncompress

Correct Answer: D,E