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: