1 Reply Latest reply: Feb 4, 2013 4:29 AM by bigdelboy RSS

    MYSQL Developer Certification examples

    988821
      I am looking to take MySQL 5 Developer Certified Professional Exam, Part I | 1Z0-871 but would really like to see an example paper before taking the exam. I know it is recommended to look at topics but pre the Oracle buyout it was relatively simple to find example papers and practise - is this still possible - can anyone point me in the right direction (Oracle cannot!).
        • 1. Re: MYSQL Developer Certification examples
          bigdelboy
          985818 wrote:
          I am looking to take MySQL 5 Developer Certified Professional Exam, Part I | 1Z0-871 but would really like to see an example paper before taking the exam. I know it is recommended to look at topics but pre the Oracle buyout it was relatively simple to find example papers and practise - is this still possible - can anyone point me in the right direction (Oracle cannot!).
          1) There are no practice tests directly available from oracle

          http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=208

          2) The exam page is here:

          http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-871&p_org_id=&lang=

          - there are no sample questions (pre MySQL sun days the MySQL website used to contain 10 sample question per exam, these have disappeared with the moves to Sun then Oracle.
          - It says the exam is validated against 5.0, 5.1, 5.5

          3) Matthew Morris gathered a basic set of resources here:

          http://www.oraclecertificationprep.com/apex/f?p=OCPSG:EXAM_DETAILS:0::NO::P2_EXAM:1Z0-871

          ... In particular I suggested he added the "MySQL 5.0 Certification Study Guide " as I believe it still probably remains the key reference source for these exams. There are a number of questions after each chapter (Reading the review this may only be on the CDROM ... that isn't the case for MySQL DBA Cluster exam book .... but may be for the earlier one ... this is relevant if you buy an electronic edition). If you learn the material first, then see these questions for the first time, they should give you a indictor of exam readiness.
          ...........................

          If you seek exam questions on the net I am reasonable sure you will find only braindumps etc ... which are to be avoided ... as they are cheating:
          https://blogs.oracle.com/certification/entry/0859_01

          ............................

          My personal opinion (not authorative) is that this exam is unlikely to have changed much from the pre- Oracle/Sun days. The statement on the exam page "This exam has been validated for MySQL 5.0, 5.1 and 5.5" indicates this is essentially remains the MySQL 5.0 but that questions have been checked to ensure they remain valid for 5.1 and 5.5( often affects DBA exams more ... often caused by later versions removing a restriction or odd behavior that was appropriate to test the candidate for on earlier versions). Questions not meeting that critieria will have been modified/removed/replaced. Questions should not be present that rely on 5.1 and 5.1 features.

          Edited by: bigdelboy on Feb 4, 2013 2:27 AM ... check checked in the book ... the questions are cdrom only ... from what i now recall they do not have an associated test engine .. PDF work form only. It is possibly they are not chapter related ... only exam related.