Free 1Z0-921 Questions for Oracle MySQL 2021 Implementation Essentials 1Z0-921 Exam as PDF & Practice Test Engine

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

Exam Questions: 78
Updated On: Oct 04, 2026

Question #1

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. Execute the purge binary logs statement without argument.

B. To safely purge binary log files, perform these steps:

C. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.

D. On the Master server, disable binlog by removing the --log-bin option.

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

Discussion 0

Correct Answer: B,C Vote an answer

Question #2

Which statement is used to create a new MySQL database?
Response:

A. CREATE TABLE

B. CREATE DATABASE

C. CREATE SCHEMA

D. NEW DATABASE

Discussion 0

Correct Answer: B Vote an answer

Question #3

Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

A. Only the t2 table is created.

B. Both the tables, t1 and t2, are created.

C. Only the t1 table is created.

D. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

Discussion 0

Correct Answer: B Vote an answer

Question #4

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

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 MySQL Enterprise High Availability to access one of the available data tables

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 mysqldump to import data from the sakila_dummy database sample data set.

Discussion 0

Correct Answer: C Vote an answer

Question #6

When should you perform a backup in a MySQL database?
Response:

A. After critical data updates or before making significant changes to the database.

B. Only during scheduled maintenance windows.

C. After every successful query execution.

D. Only when the database size exceeds a certain limit.

Discussion 0

Correct Answer: A Vote an answer

Question #7

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

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

B. Tablespace keys are managed manually behind the scenes.

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

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

Discussion 0

Correct Answer: A Vote an answer

Question #8

Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

A. Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.

B. Allocating more CPU to the database instance to improve throughput performance.

C. Increasing the storage capacity so that the database can store more data to scale.

D. Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.

E. Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.

Discussion 0

Correct Answer: C Vote an answer

Free 1Z0-921 Questions for Oracle MySQL 2021 Implementation Essentials 1Z0-921 Exam as PDF & Practice Test Engine

Download Free Oracle 1Z0-921 Demo