Código: 1Z0-874

Prova MySQL 5 Database Administrator Certified Professional Exam, Part II
Preço US$ 125.00
Duração 90 minutos
Número de questões 65
Nota de aprovação 66%
Treinamento oficial recomendado MySQL for Database Administrators

Tópicos do exame

Section 1: Stored Routines (5%)
Using Stored Routines and Triggers for Security Purposes
Using Stored Routines to Enhance Performance
Section 2: User Management (20%)
User Account Management
Client Access Control
Section 3: Securing the Server (10%)
Security Issues
Operating System Security
Filesystem Security
Log Files and Security
Network Security
FEDERATED Table Security
Section 4: Upgrade-Related Security Issues (5%)
Upgrading the Privilege Tables
Security-Related SQL Mode Values
Security-Related SQL Mode Values
Identifying Candidates for Query Analysis
Using EXPLAIN to Analyze Queries
Using SHOW WARNINGS for Optimization
MyISAM Index Caching
Section 6: Optimizing Schemas (15%)
General Table Optimizations
Normalization
MyISAM-Specific Optimizations
InnoDB-Specific Optimizations
MERGE-Specific Optimizations
MERGE-Specific Optimizations
Section 7: Optimizing the Server (10%)
Interpreting mysqld Server Information
Measuring Server Load
Tuning Memory Parameters
Using the Query Cache
Section 8: Interpreting Error Messages (5%)
Sources of Diagnostic Information
Using the Error Log for Diagnostic Purposes
Using The Slow Query Log for Diagnostic Purposes
Section 9: Optimizing the Environment (5%)
Choosing Hardware for MySQL Use
Configuring Disks for MySQL Use
Network Issues
Optimizing the Operating System for MySQL Use
Section 10: Scaling MySQL (10%)
Using Multiple Servers
Replication