1Z0-908 MySQL 8.0 Database Administration Exam

Earn associated certifications
Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.

Oracle Certified Professional, MySQL 8.0 Database Administrator

Format:
Duration: 140 Minutes
Exam Price: Rs.40,575
Number of Questions: 85
Passing Score: 62%
Validation: Exam has been validated against MySQL 8.0

Take recommended training
Complete one of the courses below to prepare for your exam (optional):

MySQL for Database Administrators Ed 5

In the subscription:
Additional Preparation and Information

A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Review exam topics

Architecture
Configure client connections to the server
Understand how MySQL stores data
Understand how InnoDB stores data and logs
Configure buffers and caches
Understand and use the Data Dictionary

Server Installation and Configuration
Install and use the MySQL server and client programs
Identify the files and folders created during installation
Start and stop MySQL
Upgrade MySQL
Configure MySQL by using options and option files
Configure MySQL variables
Launch multiple MySQL servers on the same host

Security
Create user accounts and roles
Use authentication plug-ins
Control user and role permissions
Recognize common security risks
Secure MySQL server connections
Provide password and login security
Secure the MySQL host environment
Prevent SQL injection attacks
Encrypt MySQL data
Configure MySQL Enterprise Firewall

Monitoring and Maintenance
Configure and view MySQL log files
Monitor MySQL processes and status
Configure MySQL Enterprise Audit
Use MySQL Enterprise Monitor to view activity in MySQL
Monitor database growth and explain capacity planning
Troubleshoot problems with locked resources

Query Optimization
Examine how MySQL optimizes queries
Analyze queries with MySQL Enterprise Monitor
Create indexes to improve server performance
Monitor and understand index statistics

Backups and Recovery
Distinguish between the different types of backup
Implement a backup strategy
Backup and restore data with MySQL Enterprise Backup
Use mysqldump and mysqlpump to perform logical backups
Explain when and how to use raw file backups
Back up the binary log

High Availability Techniques
Explain how replication provides high availability and scalability
Configure replication
Explain the role of the binary log in replication
Configure multisource replication
Explain the role of replication threads
Monitor and troubleshoot replication
Describe MySQL InnoDB cluster and Group Replication
Configure a MySQL InnoDB cluster
Perform an InnoDB cluster recovery

QUESTION 1
Which three are characteristics of a newly created role? (Choose three.)

A. It can be dropped using the DROP ROLE statement.
B. It is stored in the mysql.role table.
C. It is created as a locked account.
D. It can be renamed using the RENAME ROLE statement.
E. It can be granted to user accounts.
F. It can be protected with a password.

Correct Answer: AEF

QUESTION 2
Which statement is true about InnoDB persistent index statistics?

A. Updating index statistics is an I/O expensive operation.
B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
F. Tables are scanned and index statistics recalculated when an instance is restarted.

Correct Answer: D

QUESTION 3
You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?

A. installing and configuring the Connection Control plugin
B. avoiding concatenation of SQL statements and user-supplied values in an application
C. using stored procedures for any database access
D. using PREPARED STATEMENTS

Correct Answer: C