Well, I took the Oracle 12c OCP upgrade exam this morning and didn’t pass it. I’ve spent many hours over the past weeks and months reading up on new 12c features and it wasn’t enough. I also installed 12c databases and tested out a variety of features to no avail.
Ultimately my downfall was that I tried to prepare for the test from the manuals and the descriptions of what the test covered. Also, I purchased the Kaplan TestPrep software which only covered the first part of the 12c upgrade exam and only included 50 questions.
I should have waited until an upgrade exam book came out and I should have gotten the more comprehensive Transcender software so I would have a more complete set of questions and a better idea what would be covered. I can’t study everything.
If you don’t know the 12c OCP upgrade exam has a new “Key DBA Skills” section which wasn’t present in earlier exams. You have to pass both sections. The first section covers the new 12c features and corresponds to the previous exams. I passed this section, although barely, even though I felt confident going in that I would get a high percentage. The breadth of the topics covered by the second section worried me because I can’t study everything. It definitely covered things I didn’t study including some features I’ve never used.
Both parts of the exam were challenging. It seems like a pretty tough test. I’ve got my Oracle 7, 9,10, and 11 certifications and I’ve passed all of those tests on the first try so this is my first failure. So, I’m trying to regroup and think about where to go from here.
Ideally, I’d like to get Sam Alapati’s book after it comes out on Amazon and get the Transcender software as well but that costs some money. Also, I’m thinking I need to take some time and write-up some study sheets for myself instead of trying to commit everything to memory and hoping I remember during the test.
Anyway, I thought I would share my failure with the community and hope it helps someone else prepare. The truth is that even though it is embarrassing to fail the test I learned things in the process that I can use at my job. It would be great to get the piece of paper and I hope to do so by the end of the year, but I’ve already learned a ton through what I’ve done so far.