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