Get Instant Access to 1Z0-921 Practice Exam Questions [Q31-Q50]

Rate this post

Get Instant Access to 1Z0-921 Practice Exam Questions

Reliable Study Materials & Testing Engine for 1Z0-921 Exam Success!

To pass the Oracle 1Z0-921 (MySQL 2021 Implementation Essentials) Certification Exam, candidates must have a solid understanding of MySQL concepts and be familiar with MySQL tools and utilities. They should also have hands-on experience with MySQL databases and be able to troubleshoot common issues. Additionally, candidates should have a good understanding of database security, performance tuning, and high availability solutions. With the Oracle 1Z0-921 certification, professionals can demonstrate their expertise in MySQL and increase their career opportunities in the IT industry.

NEW QUESTION 31
Which two statements are correct about MySQL Enterprise Edition?

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

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

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

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

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

NEW QUESTION 32
Which three are requirements for MySQL Group Replication (GR)?

Data to be replicated must be stored in the InnoDB transactional storage engine.

The use of global transaction identifiers is required.

Primary keys are required on every replicated table.

GR only works with MySQL versions 8.0.12 or higher.

The binary log format must be set to mixed.

The minimum number of required nodes for achieving a consensus is two.

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

creating e-mail alerts and SNMP traps for MySQL warnings

starting and stopping the MySQL instance

analyzing executed MySQL queries

deploying MySQL agent on supported target operating system

monitoring the availability of the MySQL Instance

tracing import and export with mysqldump

NEW QUESTION 34
Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

MySQL Enterprise Audit

MySQL Enterprise Scalability

MySQL Enterprise No-Login Authentication

MySQL Enterprise Transparent Data Encryption (TDE)

MySQL Enterprise Data Masking and De-identification

NEW QUESTION 35
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?

Browser pop-ups

Direct support call from an Oracle representative

SMS-notification tab on the dashboard

Application-to-application messaging

NEW QUESTION 36
What three are ways to export and import data in MySQL Workbench?

Result Data Export and Import

Binary Data Export and Import Wizard

SQL Data Export and Import Wizard

Backup Data Export and Import Wizard

Table Data Export and Import Wizard

Data Modeling Import Export Wizard

NEW QUESTION 37
Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

The number of machines per group must be 3, 5, 7 or 9.

use SSD,s for data and replication logs

Groups must be in even numbers; 2, 4, 6, 8.

isolated machine resources

Use Network-attached storage (NAS) for the data files.

smaller VM,s work best – with a maximum of eight vCPU,s and 16GB of RAM

Networks must be in separate regions.

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

SHOW STATUS PLUGINS WHERE Name= ‘PARTITIONING’;

SHOW PLUGINS WHERE Name= ‘partition’;

SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= ‘partition’;

USE SYS SCHEMA; SHOW PLUGINS STATUS;

NEW QUESTION 39
Which is true about inserting an additional line in a single document stored in MySQL document store?

You specify the new element,s position in the JSON_ARRAY_INSERT statement.

Any new lines can only be inserted at the end of the document.

You cannot insert a single line, you have to replace the entire document with a new document.

The path specified must be an array position past the end of an array using the JSON_POSITION statement.

NEW QUESTION 40
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?

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.

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

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.

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.

NEW QUESTION 41
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?

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

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

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

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

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

NEW QUESTION 42
Which statement would you use to remove the population column from the city table?

ALTER TABLE city DROP population;

DELETE population FROM city;

ALTER TABLE city DELETE population;

ALTER TABLE city LESS population;

DROP population FROM city;

NEW QUESTION 43
Which activity will take place if a table is created with both the compression and encryption options?

The compression is performed before tablespace data is encrypted.

The tablespace data is encrypted first and then compression is performed.

The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.

The compression is performed, the ”data_at_rest_flag” is turned on and the tablespace data is encrypted.

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

a TRIGGER on the child table for cascading delete statements

a REFERENCES in the child table to the parent table

unique PRIMARY key values for both child and parent tables

the SET_FOREGIN variable in the my .cnf file

an index on the foreign key

NEW QUESTION 45
What are the two main components required to set up persistent storage for MySQL on Kubernetes?
Response:

PVC (Persistent Volume Claim) and ConfigMap

Secret and Deployment

Pod and ReplicaSet

PVC (Persistent Volume Claim) and PV (Persistent Volume)

NEW QUESTION 46
When should you perform a backup in a MySQL database?
Response:

Only during scheduled maintenance windows.

After critical data updates or before making significant changes to the database.

After every successful query execution.

Only when the database size exceeds a certain limit.

NEW QUESTION 47
An Oracle Cloud Infrastructure customer already has many database instances configured and running in the cloud; however, they are reporting that they are unable to create any more instances.
What could be the problem?

The customer does not have proper user rights.

The customer reached the database instance limit of 32.

The customer account might have reached resource quota/limits.

The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to-date.

NEW QUESTION 48
You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

You can expect an outage of your MySQL OCI instance during the planned time..

Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

You need to agree to the maintenance windows. If not, you are not affected by the outage.

There are no maintenance operations planned. You need to do them manually.

NEW QUESTION 49
Which is a correct example of creating an Enterprise Encryption function?

SET @function = CREATE_ASYMMETRIC_PRIV_KEY(@algo, @key_len);

CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME ,openss1_udf.so,;

INSERT INTO t1 (key_co1) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(,RSA,, 1024));

VALIDATE FUNCTION create_asymmetric_priv_key WITH ,openssl_udf.so’;

NEW QUESTION 50
The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server.
Which statement is correct?

The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

MySQL Enterprise Monitor creates the required users automatically.

The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.

Monitoring metrics need super and root privileges because they are not available for a less-privileged user.