We're so confident of our products that we provide no hassle product exchange.
SUN 310-811 Exam Overview:
| Certification Vendor: | Sun Microsystems (acquired by Oracle) |
|---|---|
| Exam Name: | Sun Certified MySQL 5.0 Database Administrator Part II |
| Exam Number: | 310-811 / CX-310-811 |
| Certificate Validity Period: | Retired, no longer valid |
| Exam Format: | Multiple Choice, Multiple Response |
| Available Languages: | Japanese, English |
| Passing Score: | 61% |
| Exam Duration: | 90 minutes |
| Exam Price: | USD $195 |
| Related Certifications: | Sun Certified MySQL 5.0 Database Administrator Part I (310-810) |
| Real Exam Qty: | 65 |
| Recommended Training: | MySQL 5.0 Database Administration Training |
| Exam Registration: | Oracle University Certification |
| Sample Questions: | SUN 310-811 Sample Questions |
| Exam Way: | Delivered via Prometric testing centers; now retired |
| Pre Condition: | Passing exam 310-810 (Sun Certified MySQL 5.0 Database Administrator Part I) |
| Official Syllabus URL: | https://education.oracle.com/ |
SUN 310-811 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Backup and Recovery | 20% | - Using mysqldump and mysqlhotcopy - Restoring databases and tables - Backup types and strategies - Binary log and point-in-time recovery |
| Topic 2: Replication | 20% | - Configuring master and slave servers - Replication troubleshooting - Replication architecture - Monitoring replication status |
| Topic 3: Stored Programs and Triggers | 20% | - Trigger definition and management - Creating and using stored functions - Views and updatable views - Creating and using stored procedures |
| Topic 4: Security and Access Control | 20% | - Network security and encryption - Restricting resource usage - User accounts and privileges - Managing passwords and authentication |
| Topic 5: Performance Optimization and Troubleshooting | 20% | - Server configuration tuning - Index strategy and usage - Error log analysis and problem diagnosis - Query optimization techniques |
By Darnell
