MySQL 2021 Implementation Essentials (1Z0-921) Free Practice Test

Question 1

Which two methods help prevent MySQL security risks?

A. Transmit plain (unencrypted) data over networks.

B. Grant only permissions that a user requires.

C. Use the secure installation script "mysql_alays_secure_installation".

D. Allow unauthorized clients to connect to the server.

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

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

Correct Answer: A,D

Question 2

After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?

A. The root password displayed on the screen via a [warning] message.

B. The root password inserted in the error log set by the --log-error=[file_name] variable

C. The root password is not given and is blank. You must manually set the root password.

D. As root, execute the show password command by using the SHA-256 password encryption plug-in.

E. The root_pw variable stored in the mysq1.install table.

Correct Answer: D,E

Question 3

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?

A. plugin-load=audit_log.so

B. audit_log_permanent=ON

C. LOAD PLUGIN=AUDIT_LOG

D. audit-log=FORCE_PLUS_PERMANENT

E. plugin-audit=ON, ALWAYS

Correct Answer: B,D

Question 4

You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

A. CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;

B. CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)

C. CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE

D. CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)

E. CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;

Correct Answer: B

Question 5

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

A. tracing import and export with mysqldump

B. starting and stopping the MySQL instance

C. monitoring the availability of the MySQL Instance

D. creating e-mail alerts and SNMP traps for MySQL warnings

E. analyzing executed MySQL queries

F. deploying MySQL agent on supported target operating system

Correct Answer: A,D,F

Question 6

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 7

What is Kubernetes in the context of MySQL?
Response:

A. A database engine for MySQL.

B. A cloud service provided by Oracle for MySQL databases.

C. An open-source container orchestration platform.

D. A database management tool for MySQL.

Correct Answer: C

Question 8

Which three are characteristics of the JSON data type?

A. It validates the JSON syntax on insert or merge.

B. It supports indexing directly against the JSON-defined column.

C. Key or array references enable quick read-access to look up document elements directly.

D. A set of SQL functions substantially support the SQL utilization of the data type.

E. Comparisons of JSON values are not case-sensitive.

F. It is based on the TEXT data type.

Correct Answer: A,B,C

Welcome to TestSimulate

Oracle MySQL 2021 Implementation Essentials (1Z0-921) Free Practice Test