Exam Number: 1Z0-883
Exam Title: MySQL 5.6 Database Administrator
Associated Certification Paths
Oracle 1Z0-883 Certification Details:
| Exam Name |
MySQL 5.6 Database Administrator |
| Exam Code |
1Z0-883 |
| Exam Product Version |
MySQL Database Administration |
| Exam Price |
USD $245 |
| Duration |
150 minutes |
| Number of Questions |
100 |
| Passing Score |
60% |
| Validated Against |
Exams are based on General Availability (GA) versions of MySQL 5.6. |
| Format |
Multiple Choice |
| Recommended Practice |
1Z0-883 Online Practice Exam |
| Recommended Training |
MySQL for Database Administrators |
Oracle 1Z0-883 Certification Topics:
| MySQL Architecture |
- Use MySQL client programs to interface with the MySQL Server interactively and in batch
- Describe how MySQL uses disk and memory resources
- List and describe key characteristics of standard MySQL storage engines including InnoDB, NDB, MyISAM, MEMORY, FEDERATED
|
| MySQL Server Installation, Configuration and Maintenance |
- Select, deploy, start and stop MySQL using appropriate binary packages for Windows and Linux platforms
- Configure MySQL Server deployments using options files, command-line options and server variables.
- Identify, configure, locate and describe appropriate use cases for MySQL the error, binary, general query and slow query log.
|
| MySQL Security |
- Describe appropriate steps to secure a MySQL deployment at the operating system, filesystem and network levels.
- Create and maintain user accounts with appropriate privileges and configuration.
- Deploy and configure MySQL Enterprise Audit
|
| Diagnostic Data and Metadata Sources in MySQL |
- Configure and leverage PERFORMANCE_SCHEMA tables to identify and diagnose performance problems.
- Obtain MySQL metadata from INFORMATION_SCHEMA tables
|
| Optimizing MySQL Performance |
- Demonstrate ability to diagnose and optimize poorly-performing queries.
- Tune MySQL Server configuration for best performance.
- Apply best practices in optimizing schema objects
- Demonstrate understanding of locking concepts as applied to MySQL Server and storage engines.
- Create and utilize table PARTITIONING
|
| Backups and Recovery in MySQL |
- Create and restore logical backups using mysqldump
- Create and restore binary backups
- Use backups for data recovery
|
| High Availability Techniques for MySQL |
- Describe, configure, deploy and troubleshoot MySQL replication
- Describe and contrast characteristics of common MySQL high availability solutions (MySQL Cluster, DRBD, Windows Failover Clustering, Solaris Cluster, OVM Template for MySQL Enterprise)
|
Oracle 1Z0-883 - MySQL 5.6 Database Administrator Exam Preparation:
