[Q33-Q55] Pass 1Z1-921 Exam in First Attempt Guaranteed 100% Cover Real Exam Questions [Jan-2025]

ExamBoosts January 9, 2025 1Z1-921 > Oracle 0

Rate this post

Pass 1Z1-921 Exam in First Attempt Guaranteed 100% Cover Real Exam Questions [Jan-2025]

Valid 1Z1-921 test answers & Oracle 1Z1-921 exam pdf

Oracle 1Z0-921 exam covers a wide range of topics related to MySQL database implementation, including database design, installation and configuration, security, backup and recovery, performance tuning, and troubleshooting. Candidates are expected to have a thorough understanding of all these topics to pass the exam successfully.

QUESTION 33
By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.

MySQL Enterprise Backup will back up from Slave automatically.

It provides multi-master access where the application can write and read data across the database servers.

It allows backup to be done on the slave without impacting the master.

You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

QUESTION 34
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.

QUESTION 35
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.

QUESTION 36
Which three statements are true about MySQL Enterprise Backup?

It performs hot or warm backups.

It provides the ability to create incremental backups.

It cannot back up encrypted tablespaces.

It enables you to take non-locking backups.

It performs logical backups.

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

QUESTION 38
The user ‘fwuser’@’localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser” @* localhost* user. Which statement should you run to accomplish this?

QUESTION 39
Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

MySQL Servers with Group Replication to replicate data to all members of the cluster.

MySQL Online Hot Backup to keep data consistent and always ready to be used.

MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.

MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.

MySQL Router to ensure client requests are load balanced and routed to the correct servers.

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

QUESTION 41
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.

QUESTION 42
The user -os-user’@”localhost” was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO “OS-user*@”localhost’;
Which three are commands that the os-user can execute?

SHOW PROCESSLIST;

SHUTDOWN

SHOW STATUS;

SHOW BINLOG EVENTS;

KILL PROCESS;

GRANT PROXY

QUESTION 43
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’;

QUESTION 44
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.

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

CREATE DATABASE

CREATE SCHEMA

CREATE TABLE

NEW DATABASE

QUESTION 46
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?

Create user by using CREATE USER ‘newuser’ @’localhost’ SET PASSWORD AS ‘Sh@256Pa33’;

Add –default_authentication_plugin=sha256_password on the command line when you invoke the server.

Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

Create user by using CREATE USER ‘newuser’@’localhost’ IDENTIFIED WITH ‘Sh@256Pa33’;

QUESTION 47
Which statement adds a column with the largest integer data type?

ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;

ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;

ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);

ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);

QUESTION 48
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?

audit_log_permanent=ON

audit-log=FORCE_PLUS_PERMANENT

plugin-load=audit_log.so

plugin-audit=ON, ALWAYS

LOAD PLUGIN=AUDIT_LOG

QUESTION 49
Which two statements are true about MySQL Enterprise Authentication?

MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.

MySQL Enterprise Authentication determines what operation the user can perform.

MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).

MySQL Enterprise Authentication supports Windows Active Directory.

MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..

QUESTION 50
Which query will find rows in a table that have no counterpart in another table?

SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;

SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;

SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;

SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;

QUESTION 51
An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

MySQL Enterprise Backup does not back up system data so that it is much faster.

MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.

mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.

mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.

mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

QUESTION 52
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

QUESTION 53
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.

QUESTION 54
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?