1Z0-883: MySQL 5.6 Database Administrator

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: