MySQL 2019 Implementation Essentials (1Z0-920) Free Practice Test

Question 1

Which two methods help prevent MySQL security risks?

A. Transmit plain (unencrypted) data over networks.

B. Use the secure installation script "mysql_alays_secure_installation".

C. Allow unauthorized clients to connect to the server.

D. Use a firewall to control access to MySQL ports.

E. Ensure that MySQL accounts have short and easy passwords.

F. Grant only permissions that a user requires.

Correct Answer: A,C

Question 2

What are Security Lists in Oracle Cloud Infrastructure?

A. They contain rules established by HIPAA for securing end-user data.

B. They are user-role designations that assign rights to certain internal users and external users.

C. They are essentially firewall rules that help control traffic between OCI instances.

D. Security lists are data encryption levels that control who can see the data.

E. They allow administrators access to applications in the cloud and external servers.

Correct Answer: C

Question 3

Which Oracle product is certified to work with MySQL Enterprise Edition?

A. Oracle Enterprise Manager

B. Oracle Application Express

C. Oracle Data Pump

D. Oracle Enterprise Backup

Correct Answer: A

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

Question 4

Which two statements are correct about MySQL Enterprise Edition?

A. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.

B. Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II).

C. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

D. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.

E. MySQL configuration can be changed in /etc/lib/myi.cnf.

Correct Answer: B,E

Question 5

Which three options are valid reasons for using a primary key in a table?

A. automatic storage of data in a sorted order

B. exporting data faster with mysqldump

C. maintaining a history of row insertions or updates

D. preventing duplicate keys

E. increasing performance when using select statements

F. to make it easier to change the PRIMARY KEY value

Correct Answer: B,D,E

Question 6

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

A. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.

B. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.

C. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.

D. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.

Correct Answer: B

Question 7

What SQL keyword must be specified when creating a foreign key constraint?

A. the SET_FOREGIN variable in the my .cnf file

B. unique PRIMARY key values for both child and parent tables

C. an index on the foreign key

D. a REFERENCES in the child table to the parent table

E. a TRIGGER on the child table for cascading delete statements

Correct Answer: E

Welcome to TestSimulate

Oracle MySQL 2019 Implementation Essentials (1Z0-920) Free Practice Test