100% Accurate Answers! Jul-2025 1Z1-921 Actual Real Exam Questions
Best Value Available! 2025 Realistic Verified Free 1Z1-921 Exam Questions
NEW QUESTION # 45
After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?
- A. The root_pw variable stored in the mysq1.install table.
- B. The root password displayed on the screen via a [warning] message.
- C. The root password inserted in the error log set by the --log-error=[file_name] variable
- D. The root password is not given and is blank. You must manually set the root password.
- E. As root, execute the show password command by using the SHA-256 password encryption plug-in.
Answer: A,E
NEW QUESTION # 46
Which three are recommended configurations for installing and running MySQL InnoDB Cluster?
- A. use SSD,s for data and replication logs
- B. Use Network-attached storage (NAS) for the data files.
- C. The number of machines per group must be 3, 5, 7 or 9.
- D. Groups must be in even numbers; 2, 4, 6, 8.
- E. isolated machine resources
- F. smaller VM,s work best - with a maximum of eight vCPU,s and 16GB of RAM
- G. Networks must be in separate regions.
Answer: B,C,D
NEW QUESTION # 47
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?
- A. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
- B. A browser-based wizard to remotely deploy the MySQL Monitor Agent
- C. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
- D. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
- E. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
Answer: A,D,E
NEW QUESTION # 48
Which two statements are true about MySQL Enterprise Firewall?
- A. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
- B. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
- C. 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.
- D. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
- E. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
- F. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
Answer: B,D
NEW QUESTION # 49
Which two statements about the download of MySQL Enterprise Backup are correct?
- A. MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.
- B. MySQL Enterprise Backup comes with all MySQL editions including community edition.
- C. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.
- D. MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.
- E. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).
Answer: B,D
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?
- A. 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.
- B. Monitoring metrics need super and root privileges because they are not available for a less-privileged user.
- C. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.
- D. MySQL Enterprise Monitor creates the required users automatically.
Answer: A
NEW QUESTION # 51
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?
- A. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
- B. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
- C. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
- D. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
Answer: A,D
NEW QUESTION # 52
Which two statements are true about MySQL Enterprise Authentication?
- A. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
- B. MySQL Enterprise Authentication supports Windows Active Directory.
- C. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
- D. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
- E. MySQL Enterprise Authentication determines what operation the user can perform.
Answer: A,B
NEW QUESTION # 53
Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?
- A. You can connect directly to the VCN without a define subnet.
- B. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.
- C. You must have an IPSec VPN to connect to an Oracle Linux instance.
- D. You can connect directly to an instance over the internet, without a public IP address.
- E. Your instance does not have a public IP address, so you cannot connect with a public subnet.
Answer: A,D
NEW QUESTION # 54
Which three options are valid reasons for using a primary key in a table?
- A. automatic storage of data in a sorted order
- B. increasing performance when using select statements
- C. to make it easier to change the PRIMARY KEY value
- D. maintaining a history of row insertions or updates
- E. exporting data faster with mysqldump
- F. preventing duplicate keys
Answer: B,E,F
NEW QUESTION # 55
The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 56
Which three statements describe MySQL Enterprise Backup?
- A. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
- B. MySQL Enterprise Backup provides the point-in-time recovery functionality.
- C. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
- D. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
- E. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
Answer: A,B,D
NEW QUESTION # 57
Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?
- A. Allocating more CPU to the database instance to improve throughput performance.
- B. Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.
- C. Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.
- D. Increasing the storage capacity so that the database can store more data to scale.
- E. Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.
Answer: D
NEW QUESTION # 58
What SQL keyword must be specified when creating a foreign key constraint?
- A. a REFERENCES in the child table to the parent table
- B. a TRIGGER on the child table for cascading delete statements
- C. an index on the foreign key
- D. unique PRIMARY key values for both child and parent tables
- E. the SET_FOREGIN variable in the my .cnf file
Answer: B
NEW QUESTION # 59
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?
- A. --uncompress-and-apply-log
- B. --copy-back-and-apply-log
- C. --uncompress
- D. --decompress
- E. --apply-log-and-copy-back
Answer: B,C
NEW QUESTION # 60
When should you perform a backup in a MySQL database?
Response:
- A. Only when the database size exceeds a certain limit.
- B. After every successful query execution.
- C. Only during scheduled maintenance windows.
- D. After critical data updates or before making significant changes to the database.
Answer: D
NEW QUESTION # 61
You have created your Compute instance using an Oracle-provided Oracle Linux image.
You want to log in to your OCI Compute instance using SSH. Which three items do you need for this process?
- A. The root user
- B. The opc user
- C. SSH private key
- D. User Password
- E. Public IP address
- F. SSH public key
Answer: B
NEW QUESTION # 62
......
The 1Z0-921 exam covers a wide range of topics related to MySQL database administration, including database architecture, installation and configuration, security management, performance tuning, backup and recovery, and high availability techniques. Candidates are expected to have hands-on experience working with MySQL databases and be familiar with best practices for managing and optimizing MySQL deployments.
Actual Questions Answers Pass With Real 1Z1-921 Exam Dumps: https://interfacett.braindumpquiz.com/1Z1-921-exam-material.html