Oracle 1z1-320 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-320
Exam Name/Title: MySQL Cloud Service 2018 Implementation Essentials
Certification Provider: Oracle
Corresponding Certification: Oracle Data Management

Exam Questions: 95
Updated On: Jul 03, 2026

Question #11

Which three features are available only on MySQL Enterprise Workbench?

A. GUI for MySQL Enterprise Backup

B. MySQL Audit Log Inspector

C. Visual Performance Dashboard

D. Database Design

E. Database Migration inclusive Support

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #12

Which two MySQL features are provided exclusively with the Enterprise Edition license, in addition to the database server?

A. MySQL Enterprise Monitor

B. MySQL Replication

C. MySQL Enterprise Firewall

D. MySQL Cluster Manager

Discussion 0

Correct Answer: A,C Vote an answer

Question #13

A MySQL server (Linux-based installation, Port 3306, default) needs to be monitored. The MySQL server and the MySQL Enterprise Monitor (MEM) are located in different security zones, which are protected with a firewall. Which port must be opened for MEM agentless monitoring?

A. Port 21/tcp (ftp) from MySQL Enterprise Monitor to MySQL server

B. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor

C. Port 22/tcp (SSH) from MySQL Enterprise Monitor to MySQL server

D. Port 3306/tcp (MySQL) from MySQL Enterprise Monitor to MySQL server

Discussion 0

Correct Answer: B Vote an answer

Question #14

Which statement will display the status of the partitioning plug-in?

A. USE SYS SCHEMA; SHOW PLUGINS STATUS;

B. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM
INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';

C. SHOW PLUGINS WHERE Name= 'partition';

D. SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';

Discussion 0

Correct Answer: B Vote an answer

Question #15

When working with the Linux operating system on a database cloud instance (non-RAC), which user accounts are available for database and non-database administration?

A. root, opc-administrator, and oracle through sudo

B. administrator, opc, and oracle

C. opc, oracle, and root (through sudo)

D. admin, ora-cloud, and oracle

E. cloud-admin, oracle, and root

Discussion 0

Correct Answer: C Vote an answer

Question #16

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. --uncompress

B. --apply-log-and-copy-back

C. --uncompress-and-apply-log

D. --copy-back-and-apply-log

E. --decompress

Discussion 0

Correct Answer: A,D Vote an answer

Question #17

You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables.
Which syntax accomplishes this?

A. CREATE USER 'mysqlbackup'@localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON
*.* TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON
mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO 'mysqlbackup'@'localhost';GRANT REPLICATION CLIENT ON *.* TO 'mysqlbackup'@'localhost';GRANT SUPER ON *.* TO 'mysqlbackup'@' localhost;GRANT PROCESS ON *.* 'mysqlbackup'@'localhost';

B. CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON *.* TO ''mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO 'mysqlbackup'@localhost';

C. CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON *.* to 'mysqlbackup'@localhost';GRANT CREATE, INSERT, DROP, UPDATE ON, mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ONmysql.backup_history TO 'mysqlbackup'@'localhost';GRANT REPLICATION CLIENT ON *.* to 'mysqlbackup'@'localhost';GRANT SUPER ON *.* TO
'mysqlbackup'@'localhost';GRANT PROCESS ON *.* TO 'mysqlbackup'@'localhost';GRANT LOCK TABLES, SELECT, CREATE, ALTER ON *.* TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO 'mysqlbackup'@'localhost';

D. CREATE USER 'mysqlbackup'@localhost'IDENTIFIED BY 'new-password';

E. CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON *.* TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO 'mysqlbackup'@'localhost';GRANT REPLICATION CLIENT ON *.* TO 'mysqlbackup'@'localhost';

Discussion 0

Correct Answer: D Vote an answer

Question #18

A keyfile has been generated as follows:
# openssl rand 32 -hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?

A. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - - backup-dir=/var/tmp/backup backup-to-image

B. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup

C. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile -
-backup-dir=/var/tmp/backup backup-to-image

D. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile -
-backup-dir=/var/tmp/backup backup-to-image

E. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup - timestamp backup

Discussion 0

Correct Answer: C Vote an answer

Question #19

Identify the MySQL plug-in that is provided only with MySQL Enterprise Edition and servers to increase performance and high availability.

A. the MySQL PAM Authentication plug-in

B. the MySQL No-Login Authentication plug-in

C. the MySQL memcached plug-in

D. the MySQL Firewall plug-in

E. the MySQL Semisynchronous replication plug-in

F. the MySQL Thread Pool plug-in

Discussion 0

Correct Answer: A Vote an answer

Question #20

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor (MEM). How would you proceed?

A. Sort the "Exec" column and check for SQL queries with low QRTi values.

B. Sort the "Exec" column and check for SQL queries with high QRTi values.

C. Look for queries with big prolonged spikes in row activity/access graph in the times series graph (Query Analyzer.)

D. Look for queries with low total latency times in the Latency section in the times series graph (Query Analyzer.)

Discussion 0

Correct Answer: D Vote an answer

Download Free Oracle 1z1-320 Demo

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