SUN 310-813 Exam Information and Actual Questions

310-813
FREE EXAM DUMPS QUESTIONS & ANSWERS

Certification Vendor:	Sun Microsystems (acquired by Oracle)
Exam Name:	MySQL 5.0 Developer Certified Professional Exam, Part II
Exam Number:	310-813 (CX-310-813)
Related Certifications:	MySQL 5.0 Developer Certified Professional Exam, Part I (310-812)
Passing Score:	65%
Exam Format:	Multiple Select, Multiple Choice
Exam Duration:	90 minutes
Certificate Validity Period:	Retired, no longer valid
Exam Price:	US$125 (historical standard)
Real Exam Qty:	70
Available Languages:	English
Recommended Training:	MySQL 5.0 Developer Official Study Guide
Exam Registration:	Pearson VUE (historical provider)
Sample Questions:	SUN 310-813 Sample Questions
Exam Way:	Proctored at authorized test centers
Pre Condition:	Passing Exam 310-812 (MySQL 5.0 Developer Certified Professional Exam, Part I)
Official Syllabus URL:	https://www.oracle.com/education/certification/discontinued-exams/

Section	Weight	Objectives
Topic 1: Indexing & Query Optimization	20%	- Query rewriting and optimization strategies - Index types and usage - Optimizing schema design - Using EXPLAIN to analyze queries
Topic 2: Stored Programs & Triggers	25%	- Cursors and error handling - Triggers: creation, events and limitations - Creating and managing stored procedures - Stored functions and parameters
Topic 3: Security & Advanced Features	15%	- Data import/export and maintenance - User accounts and privilege management - Character sets and collation - Views and their use cases
Topic 4: Transactions & Concurrency	20%	- Deadlocks and resolution - Storage engine transaction support - ACID properties and transaction syntax - Isolation levels and locking mechanisms
Topic 5: Advanced Query Techniques	20%	- Complex JOIN operations - Window functions and grouping extensions - Subqueries and derived tables - UNION, UNION ALL and set operations