[May-2025 Newly Released] Pass 1Z0-921 Exam - Real Questions and Answers
Pass 1Z0-921 Review Guide, Reliable 1Z0-921 Test Engine
Oracle 1Z0-921 Exam consists of 70 multiple-choice and multiple-answer questions that must be completed within 105 minutes. 1Z0-921 exam covers a wide range of topics, including database architecture, installation and configuration, security, performance tuning, backup and recovery, and high availability. Candidates who pass the exam will earn the Oracle Certified Specialist MySQL 2021 Implementation Essentials certification, which demonstrates their proficiency in MySQL database administration.
Oracle 1Z0-921 certification exam is designed to test the skills and knowledge of professionals who want to demonstrate their expertise in implementing and maintaining MySQL databases. 1Z0-921 exam is part of the Oracle Certified MySQL Database Administrator certification track and is intended for candidates who have a solid understanding of the MySQL server and its features.
NEW QUESTION # 41
Which two statements are true about MySQL Enterprise Authentication?
- A. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
- B. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
- C. MySQL Enterprise Authentication supports Windows Active Directory.
- D. MySQL Enterprise Authentication determines what operation the user can perform.
- E. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
Answer: B,C
NEW QUESTION # 42
You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?
- A. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
- B. Go to the configuration section (MEM) and configure the default login credentials.
- C. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.
- D. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
Answer: C
NEW QUESTION # 43
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?
- A. plugin-load=audit_log.so
- B. audit-log=FORCE_PLUS_PERMANENT
- C. audit_log_permanent=ON
- D. plugin-audit=ON, ALWAYS
- E. LOAD PLUGIN=AUDIT_LOG
Answer: B,C
NEW QUESTION # 44
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?
- A.
- B.
- C.
Answer: B
NEW QUESTION # 45
What are Security Lists in Oracle Cloud Infrastructure?
- A. They allow administrators access to applications in the cloud and external servers.
- B. They are essentially firewall rules that help control traffic between OCI instances.
- C. Security lists are data encryption levels that control who can see the data.
- D. They are user-role designations that assign rights to certain internal users and external users.
- E. They contain rules established by HIPAA for securing end-user data.
Answer: B
NEW QUESTION # 46
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?
- A. Only the t1 table is created.
- B. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
- C. Only the t2 table is created.
- D. Both the tables, t1 and t2, are created.
Answer: D
NEW QUESTION # 47
You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?
- A. You can expect an outage of your MySQL OCI instance during the planned time..
- B. There are no maintenance operations planned. You need to do them manually.
- C. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
- D. You need to agree to the maintenance windows. If not, you are not affected by the outage.
Answer: A
NEW QUESTION # 48
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 is an optimized backup based on mysqldump with optimized row locking.
- C. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
- D. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
- E. MySQL Enterprise Backup provides the point-in-time recovery functionality.
Answer: A,B,E
NEW QUESTION # 49
Which two statements are true about MySQL Enterprise Firewall?
- A. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
- B. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
- C. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
- D. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
- E. 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.
- F. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
Answer: A,C
NEW QUESTION # 50
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
- B. --decompress
- C. --copy-back-and-apply-log
- D. --uncompress-and-apply-log
- E. --apply-log-and-copy-back
Answer: A,C
NEW QUESTION # 51
Which Oracle product is certified to work with MySQL Enterprise Edition?
- A. Oracle Enterprise Manager
- B. Oracle Enterprise Backup
- C. Oracle Data Pump
- D. Oracle Application Express
Answer: A
NEW QUESTION # 52
You execute this statement:
SELECT NULL=NULL;
What is the result?
- A. FALSE
- B. 0
- C. NULL
- D. TRUE
- E. 1
Answer: C
NEW QUESTION # 53
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 is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.
- C. MySQL Enterprise Backup comes with all MySQL editions including community edition.
- D. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.
- E. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).
Answer: B,C
NEW QUESTION # 54
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?
- A. 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.
- B. 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.
- C. 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.
- D. 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.
Answer: D
NEW QUESTION # 55
You need to change the password level for a test system.
Which two allow to change this level before you create new test user/passwords?
- A. SET GLOBAL validate_password_policy=,new level,;
- B. Add validate_password_policy=,new level, in the [mysqld] section of the MySQL configuration file.
- C. SET GLOBAL force_password_complex_policy=0;
- D. Add validate_password=,new level, in the [security] section of the MySQL configuration file.
Answer: A,B
NEW QUESTION # 56
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?
- A. strict or relaxed masking
- B. random data substitution
- C. dictionary substitution
- D. misspelling
- E. whitelisting and substitution
Answer: A,B,C
NEW QUESTION # 57
......
100% Free 1Z0-921 Daily Practice Exam With 78 Questions: https://www.testkingfree.com/Oracle/1Z0-921-practice-exam-dumps.html
1Z0-921 Test Engine Practice Test Questions, Exam Dumps: https://drive.google.com/open?id=1NP3LcZW6vfMUxHy9xlgTLoXSIYXCGbwB