310-810 study guide
Sun Certified MySQL 5.0 Database Administrator Part I (CX-310-810)
310-810 Exam Product Description
With the title of Certified MySQL DBA on your resume, you have proof that you master server-related issues, such as installing a server from scratch, keeping the server running smoothly at all times, using the the storage engine for a given task, and analyzing the trouble spots of other users queries. The typical job role of a MySQL DBA is in setting up, managing and optimizing one or more MySQL servers in an organization, often helping a team of one or more users and programmers of MySQL products. Other tasks may include: Installing a MySQL server without assistance Troubleshooting queries that take too long to run Granting other users access to some of the databases on the server in a secure manner Ability to utilize the MySQL server architecture, the pluggable storage engine architecture, supported index types and replication setups.
310-810 Exam Details
Delivered at: Authorized Prometric Testing Centers
Prerequisites: None
Exam type: Multiple choice
Number of questions: 70
Pass score: 60%
Time limit: 90 minutes
310-810 Exam Objectives
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