Dear All,
I'm happy to tell you that I passed my 047 exam this afternoon w my score of 77. Although the score is not high, but given that I only spent 9 days on preparing this exam, this result is acceptable to me. I started to read Steve O'Hearn's book from last Tue, which took me one whole week. Then yesterday morning, I went to Oracle website to learn the other new things not covered in Steve O'Hearn's book, like pivot and unpivot clause, analytical functions, and
pattern matching. I, yesterday afternoon, then did the mock exam contained in the CD of Steve O'Hearn's book. That's the whole process of my preparation for 047. I'd say the following loudly to future exam-takers:
i) Since the 2nd edition of Steve O'Hearn's book has not come up,
you should browse SQL reference manual for the new exam topics not covered in the current edition. I'd say there were around 10 questions not covered in Steve O'Hearn's book.
ii) Don't be misguided! The mock exam in the CD of Steve O'Hearn's book has only 67 questions, but the actual exam has 75 questions. Actually I had 2 questions unanswered in my exam b/c of running out of time.
ii) Even you have prepare very carefully for this exam, don't be surprised to find very bizarre questions which should be appearing in the more advanced SQL performance tuning exam.
iii) Be ready to see quite a few questions asking you to "Choose all that apply", instead of those telling you to choose how many correct answers. I had at least 5 questions like this in my 047 exam. I didn't see such question formats in my
Java programmer OCP exam, and because of it, I'd say 047 exam is harder than 804 (Java OCP) exam. And yes my 804 score (83) is higher than 047.
Good luck for future 047 exam-takers!
Best,
S.