Oracle 1Z0-921 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: High Availability and Replication | 10% | - High availability solutions overview - InnoDB Cluster deployment - GTID-based replication - Replication concepts and setup |
| Topic 2: Backup and Recovery | 10% | - MySQL Enterprise Backup overview - Backup encryption and compression - Install and configure backup - Data import/export with MySQL Workbench |
| Topic 3: MySQL Enterprise Monitor | 10% | - Architecture: Service Manager and Agents - Query Analyzer usage - Features and benefits - Custom Advisors configuration |
| Topic 4: MySQL Security | 20% | - Data Masking and De-identification - MySQL Enterprise Audit - MySQL Enterprise Firewall - Authorization and privilege management - Transparent Data Encryption (TDE) - Password policies and authentication |
| Topic 5: Database Design | 15% | - MySQL data types - Basic SQL queries - MySQL Document Store - Indexes, constraints and joins - Table partitioning - Create and manage databases and tables |
| Topic 6: MySQL Database Service and HeatWave | 10% | - HeatWave setup and usage - Service overview and provisioning - Monitoring and management - High availability configuration |
| Topic 7: Oracle MySQL Enterprise Product Suite | 10% | - Oracle products certified to work with MySQL Enterprise Edition - Differences between MySQL Enterprise Edition, Community Edition and Standard Edition - Products and features of MySQL Enterprise Edition |
| Topic 8: Installation and Architecture | 15% | - MySQL infrastructure architecture overview - Configure MySQL Enterprise Server settings - Install MySQL Enterprise Server |
Oracle MySQL 2021 Implementation Essentials Sample Questions:
Question #1
Which two statements are true about MySQL Enterprise Firewall?
A. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
B. 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.
C. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
D. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
E. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
F. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
Question #2
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' SET PASSWORD AS 'Sh@256Pa33';
B. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
C. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
D. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
Question #3
Which statement would you use to remove the population column from the city table?
A. DROP population FROM city;
B. ALTER TABLE city DROP population;
C. ALTER TABLE city DELETE population;
D. DELETE population FROM city;
E. ALTER TABLE city LESS population;
Question #4
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?
A. 
B. 
C. 
D. 
E. 
Question #5
Which Oracle product is certified to work with MySQL Enterprise Edition?
A. Oracle Application Express
B. Oracle Data Pump
C. Oracle Enterprise Backup
D. Oracle Enterprise Manager
Solutions:
| Question #1 Correct Answer: C,F | Question #2 Correct Answer: B,C | Question #3 Correct Answer: B | Question #4 Correct Answer: A | Question #5 Correct Answer: D |
1120 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
