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

Exam Code/Number: 1Z0-920
Exam Name/Title: MySQL 2019 Implementation Essentials
Certification Provider: Oracle
Corresponding Certification: MySQL Cloud Service

Exam Questions: 70
Updated On: Jun 22, 2026

Question #15

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

A. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.

B. Use mysqldump with the - -changesonly option.

C. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.

D. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.

E. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

Discussion 0

Correct Answer: B,C Vote an answer

Question #16

An Oracle Cloud Infrastructure customer already has many database instances configured and running in the cloud; however, they are reporting that they are unable to create any more instances.
What could be the problem?

A. The customer does not have proper user rights.

B. The customer account might have reached resource quota/limits.

C. The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to-date.

D. The customer reached the database instance limit of 32.

Discussion 0

Correct Answer: D Vote an answer

Question #17

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

How would you restrict a user Joe from accessing all MySQL database objects?

A. UPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';

B. CREATE USER 'joe'@'0.0.0.0' SET Password=PASSWORD('% ! %')

C. Insert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

D. REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';

E. CREATE USER ' joe'@1' %' DENY ALL PRIVILEGES

Discussion 0

Correct Answer: C Vote an answer

Question #19

You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

Discussion 0

Correct Answer: E Vote an answer

Question #20

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. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

B. Only the t1 table is created.

C. Only the t2 table is created.

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

Discussion 0

Correct Answer: D Vote an answer

Question #21

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

A. /usr/mysql

B. /var/lib/mysql/innodb

C. /usr/bin/logs

D. /usr/redo

E. /var/lib/mysql

F. /etc/my.cnf

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Download Free Oracle 1Z0-920 Demo

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