Oracle MySQL 2021 Implementation Essentials Sample Questions:

1. Which activity will take place if a table is created with both the compression and encryption options?

A) The tablespace data is encrypted first and then compression is performed.
B) The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.
C) The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.
D) The compression is performed before tablespace data is encrypted.

2. MySQL is installed on a Linux server with the configuration:
Which two methods can change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

A) Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
B) Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
C) Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
D) Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

3. 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.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
B) The MASTER and SLAVE are grouped as one instance for monitoring.
C) The mysql.inventory 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 SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.

4. Which is a correct example of creating an Enterprise Encryption function?

A) INSERT INTO t1 (key_co1) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(,RSA,, 1024));
B) CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME ,openss1_udf.so,;
C) VALIDATE FUNCTION create_asymmetric_priv_key WITH ,openssl_udf.so';
D) SET @function = CREATE_ASYMMETRIC_PRIV_KEY(@algo, @key_len);

5. Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

A) MySQL Enterprise Monitor and MySQL Audit
B) MySQL Audit and MySQL Workbench
C) SQL Enterprise Monitor and MySQL Enterprise Authentication
D) MySQL Workbench and MySQL Enterprise Firewall

Solutions: