Forum Stats

  • 3,757,895 Users
  • 2,251,291 Discussions


Suggestion for the Preparation of 1Z0-071 Exam

ANIK KHAN Member Posts: 1

I am done with my masters in Electrical Engineering and I am really interested preparing for the " Oracle Database 12c SQL Certified Associate 1Z0-071" but I don' have any prior knowledge regarding all the topics related to this certification. I went through couple of topics in UDEMY and I felt it wouldn't that difficult to learn. I am really confused about how to start preparing for this exam and therefore, I have some questions;

1. should I be able to pass the certification with self preparation , even though I don't have prior knowledge?

2. Moreover, If I want to complete all the topics of this certification, which resources and materials I should be focusing on ?

3. If I study 7 days a week, within how many days I might be ready to participate for the exam, however I am at the beginning stage?


  • jaramill
    jaramill Member Posts: 4,299 Gold Trophy
    edited May 11, 2020 10:24AM

    To answer your questions:

    1. Yes, anything's possible.  Not trying to be funny but IF you put your mind to it, yes as both of my certifications I received were purely from self-preparation, without taking any of Oracle University's exam classes (which are very expensive). So the goal was to study on my own "free".  And I passed on my first try.  Not 100% but more than the minimum required to pass.
    2. @Matthew Morris has a link on his website for each exam that he also has a book on, gives you PLENTY of materials to study for, for each exam. I've provided the link below.  I've bought both of his books and these should be studied from as the last things to read before taking the exam.  He also has practice exams that mimic Oracle's format and timing.  He worked at Oracle and though not an authorized exam, he knows to put questions that Oracle approves.  It is the only non-Oracle certified vendor that IS NOT A BRAIN DUMPIt is safe to study from his practice exams.
    3. This question cannot be answered simply because everyone studies differently.  I can tell you this, that I "learned" how to study/learn better after my 1st certification (OCE-SQL - 1Z0-047), which prepared me for my 2nd certification (OCA-PL/SQL - 1Z0-144).   The key is to study "smarter", not necessarily longer.  For me, both exams, I studied for 4 months (1hr after work on weeknights) and then a couple of hours per day on the weekends.  The first thing you MUST read is
      1. The Oracle SQL Language documentation -->
      2. The Oracle SQL Reference documentation -->
      3. then read whatever links/books Matthew has on his list.  As you can see there's a lot.  Plan on studying for at least 3 months (unless you don't work and can study during the week).

    Hope this helps and good luck.

  • jaramill
    jaramill Member Posts: 4,299 Gold Trophy
    edited May 11, 2020 7:54PM
    ANIK KHAN wrote:I went through couple of topics in UDEMY and I felt it wouldn't that difficult to learn.

    Oh I just read the quoted line above...I looked into this website, and they are similar to "uCertify".  I gave my review about uCertify in my post about passing OCA-PL/SQL certification exam 1Z0-144.

    Read it here --> Exam 1Z0-144 (11g Program with PL/SQL) - My Review

    In that post I give my rankings on the study sites I used and I gave "uCertify" a bad review.  They were horrible (questions that technically were incorrect).  Answers that were incorrect based on the question given (and proven as I've written to them to point the actual Oracle errors).  Now with that said, they were NOT a brain dump site.  Though I do have to say that by catching these errors in content, questions and answers, it actually prepared me ironically.  But like I said I would never go back to them because of bad content.  I feel the same just by scanning Udemy's website.  I'd stick with Oracle's official practice exam site.

    UPDATED:  From my old post years ago, I see now that Transcender which was bought out by Kaplan, and became Kaplan IT Training is now CyberVista  -->

    But I would first start here at the source...Oracle!  -->

  • User_H5BXN
    User_H5BXN Member Posts: 1 Green Ribbon

    is there any best dumps for 1z0-071 certification ? if anyone knows, please comment

    I have purchased from skillcertpro but it did not work to clear the first attempt.

  • L. Fernigrini
    L. Fernigrini Data Engineer Sr Consultant Member Posts: 3,579 Silver Crown

    Dumps are illegal, if Oracle discovers that you are using them you can get your certifications revoked