New 2025 1Z1-921 Dumps for Oracle MySQL Certified Exam Questions & Answer [Q41-Q55]

August 24, 2025 admin 0 Kommentare

Diesen Beitrag bewerten

New 2025 1Z1-921 Dumps for Oracle MySQL Certified Exam Questions and Answer

Realistic Verified 1Z1-921 exam dumps Q&As – 1Z1-921 Free Update

Q41. 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’;

Q42. 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..

Q43. 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.

Q44. 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.

Q45. Which two methods help prevent MySQL security risks?

Use a firewall to control access to MySQL ports.

Transmit plain (unencrypted) data over networks.

Ensure that MySQL accounts have short and easy passwords.

Allow unauthorized clients to connect to the server.

Use the secure installation script “mysql_alays_secure_installation”.

Grant only permissions that a user requires.

Q46. 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

Q47. 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

Q48. Which Oracle product is certified to work with MySQL Enterprise Edition?

Oracle Enterprise Backup

Oracle Data Pump

Oracle Enterprise Manager

Oracle Application Express

Q49. You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY ‘SecretPass123!,;

CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;

CREATE USER ,jenny,@’%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE

CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)

CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)

Q50. 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.

Q51. 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.

Q52. 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’;

Q53. Which MySQL command is used to grant specific privileges to a user on a database?
Antwort:

GRANT

GIVE ACCESS

SET PRIVILEGES

GRANT PERMISSIONS

Q54. When should you perform a backup in a MySQL database?
Antwort:

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.

Q55. Which two statements are true about MySQL Enterprise Firewall?

On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.

MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.

System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network’s primary domain.

Laden …