MySQL 5.7OCP Exam experience sharing.

First, the registration examination www.pearsonvue.com/oracle visits above website, the registration, the appointment examination subject, the place. The subjects are as follows:

It will take US $158, about 1000 yuan.

Second, examination review:

5.7OCP examination at present no question bank leaks out, the earlier test gold content higher. Judging from my experience with this exam, the 5.7OCP exam contains about One-third of the original or approximate topic of the 5.6OCP exam. Recommended before the exam to review the topic of 5.6OCP (Baidu 1z0-883, should be able to quickly find the download link, note that there are about 100-200 questions, but the answer is not necessarily correct, you need to torture comb the correct answer).

5.7 New test Centers:

With my experience in this exam, there are these new test centers:

1. The relationship between old_alter_table=0 and ALTER TABLE drop partition 2. X509 a question 3. PAM one question 4. Mgr a question, by which way can see MGR resolve the problem of the transaction conflict

1.PS Library
2.IS Library
3.show processlist
4.show slave status
5.show Engine InnoDB Status

5. When a multi-table join is executed in the plan, the order in which the tables are displayed is based on what conditions 6. Password Check Plugin

Test the password check plug-in set to strong, import a password dictionary file, ask the following description of the error, this problem is combined with the picture

7. Password plugin Sha256_password8. The root password forgot how to get it back.

Exam Day Preparation:

Wash Haolian comb good head, with ID card and second ID (recommended Social Security card), 1 hours in advance to the test center.

Machine test. 120 minutes 75 Questions, do the problem to do fast, lest do not finish, the difficulty is the biggest in English, in fact, I am mainly a lot of questions and answers can not understand.

Check results:

Https://brm-certview.oracle.com/pls/certview/ocp_interface.home

58% points will be over.

Certificate download:

Of course you have to pass the exam to download. You can check the results on the day you finish the exam.

Https://brm-certview.oracle.com/pls/certview/ocp_interface.home

MySQL 5.7OCP Exam experience sharing.