MySQL OCP认证(文末附参考题)

比眉伴天荒 2023-07-11 06:26 13阅读 0赞

MySQL OCP认证已推出有一段时间，截至当前（2020.3）已有5.6/5.7/8.0以及实施专家的认证，可访问education.oracle.com进行了解，以下内容为5.7版本考试内容的介绍。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhaXllamF2YQ_size_16_color_FFFFFF_t_70][]

MySQL OCP 5.7的考试号是1Z0-888，120分钟的考试时间需做完75选择题，考题形式为单选和多选，正确率达到58%可通过考试。考试费目前为人民币1077元。

值得一提的是目前MySQL认证不要求有培训经历，相关的训练课程标注了“可选”，见下图，也就是说可以花费一千多块的费用直接参加考试，相对比其他的Oracle认证，这个价格确实是相对比较便宜。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhaXllamF2YQ_size_16_color_FFFFFF_t_70 1][]

目前网络上5.7 OCP相关的资料还比较少，在备考上相对Oracle OCP难度稍高，更考验个人的基本功，下面我将考试介绍中大纲部分的内容粘贴如下，共涉及10个主题。

1 Installing MySQL

*  Install MySQL
 *  Identify installed Files and Directories
 *  Understand Initial Configuration
 *  Start and Stop MySQL

2 Configuring MySQL

*  Understand Server Options, Variables, and the Command Line
 *  Define Option Files
 *  Use System Variables

3 User Management

*  Identify MySQL Privilege System
 *  Create and Modify User Accounts
 *  Configure Passwords and Account Expiration
 *  Understand Authentication Plug-Ins
 *  Grant Permissions
 *  Reset a Forgotten Root Password

4 Maintaining a Stable System

*  Define Stability
 *  Use Capacity Planning
 *  Troubleshoot
 *  Identify the Causes of Server Slowdowns
 *  Describe InnoDB Recovery

5 Backup Strategies

*  Understand Backups
 *  Create a Backup Strategy
 *  Use MySQL Backup Tools
 *  Define Raw Backup Methods
 *  Explain Techniques that Use the Binary Log

6 MySQL Architecture

*  Understand How MySQL Processes Requests
 *  Explain How MySQL Stores Data
 *  Use Tablespaces
 *  Identify Redo and Undo Logs
 *  Define How MySQL Uses Memory

7 Monitoring MySQL

*  Monitor MySQL with Log Files
 *  Monitor MySQL with Status Variables
 *  Monitor MySQL with Performance Schema

8 MySQL Security

*  Identify Security Risks
 *  Understand Network security
 *  Use Password Security
 *  Explain Operating System Security
 *  Protect Against SQL Injections

9 Optimizing Query Performance

*  Identify Slow Queries
 *  Understand the EXPLAIN statement
 *  Work with Indexes
 *  Use Index Statistics

10 Configuring a Replication Topology

*  Replicate Conflicts
 *  Explain Replication
 *  Configure Replication
 *  Use MySQL Utilities
 *  Identify Replication Threads
 *  Monitor Replication
 *  Troubleshoot Replication

为了方便阅读，我使用了Google浏览器的翻译功能将翻译后的中文页面截图如下，机器翻译仅供参考。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhaXllamF2YQ_size_16_color_FFFFFF_t_70 2][]

目前考试资料比较少，网络上流传着几个版本的题库一共不足200道可复习参考，从以上10个主题中出75道考题，对于备考还是存在一定难度的。

在考试语言环境可选中文或英文，但从已通过中文环境考试的朋友讲，中文版的考试翻译略微生硬，英文不是特别差的情况不建议选中文考试。

证书有没有必要考仍然得一分为二的看，根据自身情况，资金够、精力充足就趁早拿下，有些机会还是需要证书。

![20200304182554132.png][]

Tank

2020.3.4

参考资料

[https://education.oracle.com/mysql-57-database-administrator/pexam\_1Z0-888][https_education.oracle.com_mysql-57-database-administrator_pexam_1Z0-888]

网友整理的5.7参考资料 [链接：https://pan.baidu.com/s/15-ZtrlRl7X4F7p-kaw9laA ][https_pan.baidu.com_s_15-ZtrlRl7X4F7p-kaw9laA]  
提取码：[zb3y][https_pan.baidu.com_s_15-ZtrlRl7X4F7p-kaw9laA]

（网络资源，不保证覆盖率、答案准确率，请自行校对）

![20200304183000326.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhaXllamF2YQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2020030418214999.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhaXllamF2YQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhaXllamF2YQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2020030418242878.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhaXllamF2YQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhaXllamF2YQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200304182456614.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhaXllamF2YQ==,size_16,color_FFFFFF,t_70
[20200304182554132.png]: https://img-blog.csdnimg.cn/20200304182554132.png
[https_education.oracle.com_mysql-57-database-administrator_pexam_1Z0-888]: https://education.oracle.com/mysql-57-database-administrator/pexam_1Z0-888
[https_pan.baidu.com_s_15-ZtrlRl7X4F7p-kaw9laA]: https://pan.baidu.com/s/1kXeAlid05JkCQkfeS7WCXQ
[20200304183000326.png]: https://img-blog.csdnimg.cn/20200304183000326.png