CX-310-810 Exam Dumps
Oracle MySQL 5.0 Database Administrator Certified Professional Exam, Part I CX-310-810 real exam questions and online practice test engine by FreeCram. Try CX-310-810 exam questions for free. You can also download a free demo of the CX-310-810 exam PDF version.
Oracle's CX-310-810 actual exam materials brought to you by FreeCram group of Oracle certification experts.
View all CX-310-810 actual exam questions & answers and explanations for free.
If you like our product, you can request full access to all the latest Oracle MySQL 5.0 Database Administrator Certified Professional Exam, Part I CX-310-810 exam premium questions.
| Certification Provider: | Oracle |
|---|---|
| Exam Code / Number: | CX-310-810 |
| Exam Name: | MySQL 5.0 Database Administrator Certified Professional Exam, Part I |
| Exam Questions: | 139 |
| Corresponding Certification: | OCP |
We are already working hard to make CX-310-810 exam material available to our valued customers. If you are interested in CX-310-810 exam material, provide us your email and we will notify you.
Oracle CX-310-810 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Client Programs for DBA Work | 10% | - mysqladmin, mysqldump, mysqlcheck - mysql client - Command-line utilities usage |
| Topic 2: Locking and Concurrency | 10% | - Row-level locking - Table-level locking - Deadlock detection and resolution |
| Topic 3: Data Maintenance & INFORMATION_SCHEMA | 15% | - Table check, repair, and optimization - Metadata retrieval - INFORMATION_SCHEMA usage |
| Topic 4: Backup and Recovery | 10% | - Physical backups - Recovery procedures - Logical backups |
| Topic 5: Character Set Support | 10% | - Server/database/table/column settings - Conversion and troubleshooting - Character sets and collations |
| Topic 6: Storage Engines | 15% | - InnoDB architecture and features - MyISAM characteristics - Choosing and configuring engines |
| Topic 7: MySQL Architecture | 15% | - Query execution process - Server components and layers - Connection handling and threading model |
| Topic 8: Starting, Stopping and Configuring MySQL | 15% | - Shutdown procedures - Runtime configuration changes - Configuration files and variables - Startup methods and options |