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

Question 1

The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?

A.

B.

C.

D.

Correct Answer: B

Question 2

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 3

Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

A. Only root is allowed to access from non-localhost.

B. The OCI instance is still in the "creation" process.

C. The opc user can be used to access MySQL only with the created SSH-Key.

D. You forgot to create the correct SSL/TLC certificate during the setup process.

E. You forgot to enable port 3306.

Correct Answer: E

Question 4

Which two statements about the download of MySQL Enterprise Backup are correct?

A. MySQL Enterprise Backup comes with all MySQL editions including community edition.

B. MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.

C. MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.

D. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.

E. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).

Correct Answer: A,C

Question 5

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

A. SLAVE START

B. RUN SLAVE

C. SLAVE RUN

D. START SLAVE

E. START RUN SLAVE

Correct Answer: A

Question 6

You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Which two are possible reasons for this problem?

A. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

B. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.

C. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

D. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.

E. The MASTER and SLAVE are grouped as one instance for monitoring.

Correct Answer: C,E

Question 7

Which statement is used to create a new MySQL database?
Response:

A. CREATE SCHEMA

B. CREATE DATABASE

C. NEW DATABASE

D. CREATE TABLE

Correct Answer: B

Question 8

You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for 'test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?

A. The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.

B. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.

C. The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.

D. The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.

Correct Answer: C

Welcome to TestSimulate

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