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

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

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

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

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 MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

Discussion 0

Correct Answer: A,B,C Vote an answer

QUESTION NO: 2
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. --apply-log-and-copy-back

C. --uncompress-and-apply-log

D. --uncompress

E. --copy-back-and-apply-log

Discussion 0

Correct Answer: D,E Vote an answer

QUESTION NO: 3
An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

A. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

B. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.

C. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.

D. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.

E. MySQL Enterprise Backup does not back up system data so that it is much faster.

Discussion 0

Correct Answer: A,C Vote an answer

QUESTION NO: 4
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. Only the t1 table is created.

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

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

Discussion 0

Correct Answer: C Vote an answer

QUESTION NO: 5
You just installed MySQL by Using a Package Manager on Linux.
Where are the default InnoDB redo log files stored?

A. /usr/bin/logs

B. /usr/redo

C. /var/lib/mysql/innodb

D. /etc/my.cnf

E. /var/lib/mysql

F. /usr/mysql

Discussion 0

Correct Answer: B Vote an answer

QUESTION NO: 6
What three are ways to export and import data in MySQL Workbench?

A. Result Data Export and Import

B. SQL Data Export and Import Wizard

C. Data Modeling Import Export Wizard

D. Backup Data Export and Import Wizard

E. Binary Data Export and Import Wizard

F. Table Data Export and Import Wizard

Discussion 0

Correct Answer: A,B,F Vote an answer

QUESTION NO: 7
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. On the Master server, disable binlog by removing the --log-bin option.

B. Execute the purge binary logs statement without argument.

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

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

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

Discussion 0

Correct Answer: D,E Vote an answer

QUESTION NO: 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. Add validate_password=,new level, in the [security] section of the MySQL configuration file.

B. SET GLOBAL force_password_complex_policy=0;

C. SET GLOBAL validate_password_policy=,new level,;

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

Discussion 0

Correct Answer: C,D Vote an answer

QUALITY AND VALUE

Tested and Approved

Easy to Pass

Try Before Buy

RECENT DISCUSSIONS

Useful Links

Contact Us