Updated Jan 26, 2025 Certification Exam 1Z1-921 Dumps - Practice Test Questions [Q14-Q32]

Rate this post

Updated Jan 26, 2025 Certification Exam 1Z1-921 Dumps – Practice Test Questions

Updated Verified 1Z1-921 dumps Q&As – Pass Guarantee or Full Refund

The Oracle 1Z1-921 exam consists of 70 multiple-choice questions that must be completed within 105 minutes. The questions are designed to test the candidate’s understanding of the MySQL database management system and its associated tools, including MySQL Workbench, MySQL Enterprise Monitor, and MySQL Shell. 1Z1-921 exam is available in English and Japanese, and candidates must achieve a score of at least 63% to pass.

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

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

Q16. You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

Execute the sakila-data. sqi script to populate the database

Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;

Use MySQL Enterprise High Availability to access one of the available data tables

Use mysqldump to import data from the sakila_dummy database sample data set.

Q17. You execute this statement:
SELECT NULL=NULL;
What is the result?

FALSE

NULL

TRUE

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

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

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

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

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

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

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

Q25. Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

You can connect directly to the VCN without a define subnet.

Your instance does not have a public IP address, so you cannot connect with a public subnet.

You must have an Internet gateway to connect to a public address on an Oracle Linux instance.

You can connect directly to an instance over the internet, without a public IP address.

You must have an IPSec VPN to connect to an Oracle Linux instance.

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

Q27. You set up a compressed full backup file from mysqlbackup by using the –compress option for MySQL Database backup. You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

–uncompress-and-apply-log

–apply-log-and-copy-back

–copy-back-and-apply-log

–uncompress

–decompress

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

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

Q30. Which of the following statements is true regarding MySQL user account privileges?
Response:

A user with the SUPER privilege can only read data from the database.

The GRANT option allows a user to revoke privileges from other users.

The USAGE privilege allows a user to connect to the MySQL server but grants no other privileges.

The RELOAD privilege allows a user to delete data from a table.

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

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

Exam Engine for 1Z1-921 Exam Free Demo & 365 Day Updates: https://www.prepawaytest.com/Oracle/1Z1-921-practice-exam-dumps.html

Updated Jan 26, 2025 Certification Exam 1Z1-921 Dumps – Practice Test Questions [Q14-Q32]

Leave a Reply Cancel reply