MySQL 2019 Implementation Essentials - 1Z1-920 Exam Practice Test

Question 1

Which two statements are true about MySQL Enterprise Authentication?

A. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..

B. MySQL Enterprise Authentication determines what operation the user can perform.

C. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).

D. MySQL Enterprise Authentication supports Windows Active Directory.

E. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.

Correct Answer: C,D

Question 2

You execute this statement:
SELECT NULL=NULL;
What is the result?

A. TRUE

B. NULL

C. 0

D. 1

E. FALSE

Correct Answer: B

Question 3

What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

A. Browser pop-ups

B. Application-to-application messaging

C. Email

D. SMS-notification tab on the dashboard

E. Direct support call from an Oracle representative

Correct Answer: C,D

Question 4

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH) For accessing a new MySQL Enterprise Edition on an Oracle Cloud Infrastructure (OCI) Instance you " Add SSH key " information during the OCI instance setup. You want to use Putty from your Windows Client to install MySQL.
What are the correct steps to accomplish this?

A. Open Port 22 on your OCI Instance and configure Putty with the ssh private key.

B. Convert the private key to ppk format first and use the new private key for authentication.

C. Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.

D. Use the provided private key for authentication.

Correct Answer: C

Question 5

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

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

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

C. SHOW PLUGINS WHERE Name= 'partition';

D. USE SYS SCHEMA; SHOW PLUGINS STATUS;

Correct Answer: A

Question 6

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

A. Oracle Application Express

B. Oracle Enterprise Manager

C. Oracle Enterprise Backup

D. Oracle Data Pump

Correct Answer: B

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

Question 7

The slave connects to the master and asks for updated records. What command was issued for this to happen?

A. SLAVE START

B. START SLAVE

C. START RUN SLAVE

D. RUN SLAVE

E. SLAVE RUN

Correct Answer: A

Oracle MySQL 2019 Implementation Essentials - 1Z1-920 Exam Practice Test

Latest Update

Useful Links

Contact Us