Free Oracle 1z1-320 Exam Dumps Questions & Answers


Exam Code/Number:	1z1-320Join the discussion
Exam Name:	MySQL Cloud Service 2018 Implementation Essentials
Certification:	Oracle
Free Question Number:	95
Publish Date:	Aug 20, 2026
# of views:	2184
Rating 100%

Page: 1 / 19
Total 95 questions

Question 1

MySQL is installed on a Linux server and has the following configuration:
[mysqld]
User=mysql
Datadir=/data/mysql
Which two methods should you use to change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

A.Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
B.Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
C.Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
D.Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

Question 2

Which four options are valid reasons for using a PRIMARY KEY in a table?

A.Increasing performance when using SELECT statements
B.Preventing duplicate keys
C.Eliminating the need for accessing the database cache
D.Automatic storage of data in a sorted order
E.Maintaining a history of row insertions or updates
F.Exporting data faster with mysqldump
G.Auto-generating values via AUTO_INCREMENT

Question 3

You need to change the password level for a test system. Which two options enable 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.Add validate_password_policy='new level' in the [mysql] section of the MySQL configuration file.
C.SET GLOBAL validate_password_policy='new level';
D.SET GLOBAL force_password_complex_policy=0;

Question 4

You want to access your MySQL Cloud Service cloud environment from an external application based on ODBC. What are the required steps?

A.Switch to the Compute Cloud Service Dashboard and disable reject:*.public-internet
B.Enable SSH tunnel and access MySQL based on TCP/IP over SSH.
C.Create a new SSH key for your ODBC connector.
D.Access to the OS (SSH) and MySQL (3306) are open by default.
E.Enable ora_p2admin_mysql, which opens port 3306 on the Access Rules tab.

Question 5

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

A.the MySQL memcached plug-in
B.the MySQL Thread Pool plug-in
C.the MySQL No-Login Authentication plug-in
D.the MySQL PAM Authentication plug-in
E.the MySQL Semisynchronous replication plug-in
F.the MySQL Firewall plug-in