We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z0-908 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
Reference: https://education.oracle.com/mysql-80-database-administrator/pexam_1Z0-908
Oracle 1Z0-908 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | MySQL 8.0 Database Administrator |
| Exam Number: | 1Z0-908 |
| Available Languages: | English, Chinese (Traditional) |
| Exam Duration: | 120 minutes |
| Exam Price: | USD 245 |
| Real Exam Qty: | 73 |
| Exam Format: | Multiple Choice, Scenario-based |
| Certificate Validity Period: | Lifetime |
| Passing Score: | 62% |
| Recommended Training: | MySQL 8.0 Database Administrator Training |
| Exam Registration: | Pearson VUE Oracle Registration Oracle University Exam Page |
| Sample Questions: | Oracle 1Z0-908 Sample Questions |
| Exam Way: | Online proctored remote exam or in-person at Pearson VUE testing centers |
| Pre Condition: | No formal prerequisites; 6 months of hands-on MySQL administration experience recommended |
| Official Syllabus URL: | https://education.oracle.com/mysql-8-0-database-administrator/pexam_1Z0-908 |
How to book the Oracle 1Z0-908: MySQL 8.0 Database Exam
If you are looking to appear in the Oracle 1Z0-908: MySQL 8.0 Database Exam, you can do so by either redeeming a voucher that you must buy from Oracle or paying directly with a credit card. After payment, you can schedule the test via Oracle's external testing provider, PearsonVue.
For more info read reference:
Oracle 1Z0-908: MySQL 8.0 Database Administration
Topics of Oracle 1Z0-908: MySQL 8.0 Database Exam
The Oracle 1Z0-908 exam tests the abilities and knowledge of the candidates by checking the following objectives:
Architecture
- Understand how MySQL stores data
- Understand and use the Data Dictionary
- Understand how InnoDB stores data and logs
- Configure client connections to the server
- Configure buffers and caches
Server Installation and Configuration
- Upgrade MySQL
- Configure MySQL by using options and option files
- Install and use the MySQL server and client programs
- Launch multiple MySQL servers on the same host
- Start and stop MySQL
- Identify the files and folders created during the installation
- Configure MySQL variables
Security
- Configure MySQL Enterprise Firewall
- Prevent SQL injection attacks
- Create user accounts and roles
- Secure the MySQL host environment
- Provide the password and login security
- Encrypt MySQL data
- Use authentication plug-ins
- Control user and role permissions
- Recognize common security risks
- Secure MySQL server connections
Monitoring and Maintenance
- Use MySQL Enterprise Monitor to view activity in MySQL
- Monitor MySQL processes and status
- Monitor database growth and explain capacity planning
- Configure MySQL Enterprise Audit
- Configure and view MySQL log files
- Troubleshoot problems with locked resources
Query Optimization
- Analyze queries with MySQL Enterprise Monitor
- Create indexes to improve server performance
- Monitor and understand index statistics
- Examine how MySQL optimizes queries
Backups and Recovery
- Back up the binary log
- Backup and restore data with MySQL Enterprise Backup
- Explain when and how to use raw file backups
- Use mysqldump and mysqlpump to perform logical backups
- Distinguish between the different types of backup
- Implement a backup strategy
High Availability Techniques
- Configure replication
- Explain the role of replication threads
- Monitor and troubleshoot replication
- Describe MySQL InnoDB Cluster and Group Replication
- Configure a MySQL InnoDB cluster
- Configure multisource replication
- Explain the role of the binary log in replication
- Explain how replication provides high availability and scalability
- Perform an InnoDB cluster recovery
By Samuel
