[2025] Pass Oracle 1Z1-921 Premium Files Test Engine pdf – Free Dumps Collection [Q23-Q43]

5/5 - (2 votes)

[2025] Pass Oracle 1Z1-921 Premium Files Test Engine pdf – Free Dumps Collection

New 2025 Realistic 1Z1-921 Dumps Test Engine Exam Questions in here

Oracle 1Z0-921 exam is a computer-based test that consists of 70 multiple-choice questions. Candidates have 105 minutes to complete the exam, and the passing score is 63%. 1Z1-921 exam is available in several languages, including English, Japanese, and Portuguese. It can be taken at any authorized testing center or online through the Pearson VUE testing platform.

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

MySQL Enterprise Monitor and MySQL Audit

MySQL Workbench and MySQL Enterprise Firewall

MySQL Audit and MySQL Workbench

SQL Enterprise Monitor and MySQL Enterprise Authentication

NO.24 You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

NO.25 You just installed MySQL by Using a Package Manager on Linux.
Where are the default InnoDB redo log files stored?

/usr/mysql

/var/lib/mysql

/var/lib/mysql/innodb

/usr/bin/logs

/usr/redo

/etc/my.cnf

NO.26 Which three statements describe MySQL Enterprise Backup?

MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

MySQL Enterprise Backup provides the point-in-time recovery functionality.

MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.

MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.

MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

NO.27 Which three are characteristics of the JSON data type?

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

It supports indexing directly against the JSON-defined column.

It validates the JSON syntax on insert or merge.

Comparisons of JSON values are not case-sensitive.

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

It is based on the TEXT data type.

NO.28 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)

NO.29 Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

Both the tables, t1 and t2, are created.

Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

Only the t2 table is created.

Only the t1 table is created.

NO.30 What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

Data is encrypted automatically, in real time, after it is written to storage.

Enables data-at-rest encryption by encrypting the physical files of the database.

Encryption key is stored in a centralized key memory location

Tablespace keys are managed manually behind the scenes.

NO.31 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.

NO.32 Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

Allocating more CPU to the database instance to improve throughput performance.

Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.

Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.

Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.

Increasing the storage capacity so that the database can store more data to scale.

NO.33 Which three are levels in which MySQL Enterprise Monitor provides access control?

MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services

Asset visibility: the rights to access data collected from hosts or MySQL instances

Application administration: the rights to view or change the MySQL Enterprise Monitor configuration

Specific data access: the rights to view specific types of potentially sensitive data

MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent

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

CREATE DATABASE

CREATE SCHEMA

CREATE TABLE

NEW DATABASE

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

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

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

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

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

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

NO.36 Which two deployment architectures could you use for scaling-out database reads?

Implementing a three-node, single-primary InnoDB Cluster.

Edit the configuration file and increase the value for parallel_read_workers and reboot the server

Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.

Altering the storage engine for all tables to memory to increase performance.

Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.

NO.37 MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. Which three are MySQL Enterprise Masking and De-identification functions?

misspelling

strict or relaxed masking

random data substitution

whitelisting and substitution

dictionary substitution

NO.38 You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using – -backup-dir and by giving–hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.

1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using – -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using – – backup-dir and by specifying — config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.

1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.

NO.39 How would you restrict a user Joe from accessing all MySQL database objects?

CREATE USER ,joe’@,0.0.0.0, SET Password=PASSWORD(,% ! %,)

REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,;

UPDATE mysql.user SET Password=PASSWORD(,Invalid,) WHERE User=,joe’;

Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

CREATE USER , joe,@1′ %’ DENY ALL PRIVILEGES

NO.40 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?

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

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

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

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

NO.41 Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database

A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

A browser-based wizard to remotely deploy the MySQL Monitor Agent

NO.42 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.

NO.43 The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

On the Master server, disable binlog by removing the –log-bin option.

Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.

To safely purge binary log files, perform these steps:

Execute the purge binary logs statement without argument.

Delete all binlog files manually on the file system to release storage spaces.