In 2026, failing the Oracle MySQL Cloud Service 2018 Implementation Essentials exam means paying the full registration fee a second time — plus weeks of lost momentum. The 95 practice questions in 2Pass4sure's 1z1-320 package are designed to help you get it done on the first attempt.

Oracle 1z1-320 Exam Overview:

Oracle 1z1-320 Exam Syllabus Topics:

Oracle 1z1-320 Exam: Everything You Wanted to Ask

Oracle MySQL Cloud Service 2018 Implementation Essentials Sample Questions:

Question 1

The MySQL pluggable authentication plug-in for Windows is enabled and configured. The following command is executed on a MySQL Server:
CREATE USER 'SQL_admin'@'%' IDENTIFIED WITH authentication_windows AS 'joe, henry, "Power Users"'; Which two statements are valid?

A. When any of the named users is using a Linux Client, the user can access the MySQL Server from s MySQL Client with the password configured in the Windows Active Directory.
B. When any of the named users is using a Linux Client, the user can access the MySQL Server from a MYSQL Client with the password configured in MySQL.
C. User Joe may log in to a Windows Client and then access the MySQL Server from a MySQL Client without being asked about a password.
D. Logins are granted only if the user's client application and the corresponding MySQL instance are on the same IP address.
E. When any of the named users is using a Java application based on his or her Windows Client, no authentication is necessary to log in to MySQL.

Question 2

You have the following mysqlbackup-inc.cnf config file:

Which two commands allow MySQL Enterprise Backup to perform incremental backup based on the last full backup?

A. # mysqlbackup -defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password backup-to-incremental
B. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password incremental
C. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password --with-timestamp backup
D. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password --incremental backup-to-image
E. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password backup-incremental

Question 3

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

Question 4

The MySQL server looks for option files in standard locations. The server might read multiple files from different locations. For a Linux installation, which two methods would you use to view the options file lookup locations, the order in which they are read, and groups?

A. $ mysql - - print-defaults
B. $ mysqld - -help - -verbose | grep-A1 "Default options"
C. SHOW GLOBAL VARIABLES;
D. $ mysqld --help

Question 5

The following backup command is executed:
mysqlbackup --defaults-file=config/mysqlbackup.cnf --compress --port=3306 --host=127.0.0.1
--user=mysqlbackup --password --suspend-at-end backup
*** log started **
....
160308 14:43:00 mysqlbackup: INFO: Copying /home/mysql/data/07/test/xmltable.ibd (Barracuda file format).
160308 14:43:00 mysqlbackup: INFO: Completing the copy of innodb files.
160308 14:43:00 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
160308 14:43:00 mysqlbackup: INFO: Starting to lock all the tables...
160308 14:43:00 mysqlbackup: INFO: All tables are locked and flushed to disk mysqlbackup: INFO:
--suspend-at-end option is specified.
160308 14:43:00 mysqlbackup: INFO: Suspending the backup procedure to wait until the marker file
'/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' is deleted.
....
*** log ended **
Which option allows mysqlbackup to continue backing up the rest of the data?

A. Run a mysql command as follows.mysqlbackup will continue. mysql> resume mysqlbackup;
B. Log in to the MySQL server and identify the processid, which issues GLOBAL READ LOCK. Connect the mysql session and terminate the session for the identified "processed" .mysqlbackup will continue
C. Issue a SIGTERM to the mysqlbackup process.mysqlbackup will continue
D. Run a mysql command as follows,.mysqlbackup will continue. mysql>UNLOCK TABLES;
E. An external program or manual work is to be executed to complete the backup and the marker file
"/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' should be removed intentionally.
After the file is removed, mysqlbackup will continue

Solutions: