Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z1-320 Exam Practice Test

A. Add validate_password='new level' in the [security] section of the MySQL configuration file.

B. SET GLOBAL force_password_complex_policy=0;

C. Add validate_password_policy='new level' in the [mysql] section of the MySQL configuration file.

D. SET GLOBAL validate_password_policy='new level';

A. MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install.

B. MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. Download the MySQL Utilities separately from www.mysql.com.

C. MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution.

D. MySQL Utilities is a package from MySQL Connector. Download the MySQL/Connector and install.

E. MySQL Utilities comes with MySQL Enterprise Backup. Download MySQL Enterprise Monitor to install.

A. Database Migration inclusive Support

B. GUI for MySQL Enterprise Backup

C. Visual Performance Dashboard

D. Database Design

E. MySQL Audit Log Inspector

A. the MySQL PAM Authentication plug-in

B. the MySQL Semisynchronous replication plug-in

C. the MySQL memcached plug-in

D. the MySQL Firewall plug-in

E. the MySQL Thread Pool plug-in

F. the MySQL No-Login Authentication plug-in

A. Set Max. Queries to 14 for 'employee1'.

B. Set Max. Connections to 14 for 'employee1'.

C. Set Max. Queries to 10 for 'employee1'.

D. Set Max Updates to 4 for 'employee1'.

E. Set Concurrent Connections to 14 for 'employee1'.

A. Security rules are data encryption levels that control who can see the data.

B. These are rules established by HIPAA for securing end-user data.

C. Security are essentially firewall rules that can help to control traffic between Cloud Service instances, as well as between instances and external hosts.

D. They are user-role designation that assign rights to certain users.

E. They allow administrators access to applications in the cloud.

A. Configure MySQL to replicate data via the MySQL binlog to MEM.

B. Route MySQL SQL statements through a MySQL Monitor Proxy.

C. Configure the MySQL Router to send normalized SQL statements to MEM.

D. Configure a MySQL Connector that sends information directly to MySQL Enterprise Service Manager.

E. Configure the Performance Schema statement digests with MySQL Server 5.6.14 or later.

A. You set the firewall per database.

B. You can block out potential threats by setting up a preapproved whitelist.

C. You can automatically delete a user if the user breaks your firewall.

D. You can modify a request with a SQL statement substitution.

E. You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands.

A. 0

B. NULL

C. FALSE

D. 1

E. TRUE

A. admin, ora-cloud, and oracle

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

C. administrator, opc, and oracle

D. cloud-admin, oracle, and root

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