Código: 1Z0-873
| Prova | MySQL 5 Database Administrator Certified Professional Exam, Part I |
| Preço | US$ 125.00 |
| Duração | 90 minutos |
| Número de questões | 71 |
| Nota de aprovação | 66% |
| Treinamento oficial recomendado | MySQL for Database Administrators NEW MySQL for Database Administrators |
Tópicos do exame
| Section 1: MySQL Architecture (10%) | |
| Client/Server Overview | |
| Communication Protocols | |
| The SQL Parser and Storage Engine Tiers | |
| How MySQL Uses Disk Space | |
| How MySQL Uses Memory | |
| Section 2: Starting, Stopping, and Configuring MySQL (20%) | |
| Types of MySQL Distributions | |
| Starting and Stopping MySQL Server on Windows | |
| Starting and Stopping MySQL Server on Unix | |
| Runtime MySQL Configuration | |
| Log and Status Files | |
| Loading Time Zone Tables | |
| Security-Related Configuration | |
| Setting the Default SQL Mode | |
| Upgrading MySQL | |
| Section 3: Client Programs for DBA Work (5%) | |
| Overview of Administrative Clients | |
| mysql | |
| mysqladmin | |
| mysqlimport | |
| mysqldump | |
| Client Program Limitations | |
| Section 4: Character Set Support (5%) | |
| Performance Issues | |
| Choosing Data Types for Character Columns | |
| Section 5: Locking (10%) | |
| Locking Concepts | |
| Explicit Table Locking | |
| Advisory Locking | |
| Section 6: Storage Engines (20%) | |
| MySQL Storage Engines | |
| The MyISAM Engine | |
| The MERGE Engine | |
| The InnoDB Engine | |
| The MEMORY Engine | |
| The FEDERATED Engine | |
| The Cluster Storage Engine | |
| Other Storage Engines | |
| Section 7: Data (Table) Maintenance (10%) | |
| Types of Table Maintenance Operations | |
| SQL Statements for Table Maintenance | |
| Client and Utility Programs for Table Maintenance | |
| Repairing InnoDB Tables | |
| Enabling MyISAM Auto-Repair | |
| Section 8: The INFORMATION_SCHEMA Database (5%) | |
| INFORMATION_SCHEMA Access Syntax | |
| INFORMATION_SCHEMA Versus SHOW | |
| Limitations of INFORMATION_SCHEMA | |
| Section 9: Data Backup and Recovery Methods (15%) | |
| Introduction | |
| Binary Versus Textual Backups | |
| Making Binary Backups | |
| Making Text Backups | |
| Backing Up Log and Status Files | |
| Replication as an Aid to Backup | |
| MySQL Cluster as Disaster Prevention | |
| Data Recovery | |