This week's book giveaway is in the Programmer Certification forum.
We're giving away four copies of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 and have Jeanne Boyarsky & Scott Selikoff on-line!
See this thread for details.
Win a copy of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 this week in the Programmer Certification forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Ron McLeod
  • Carey Brown
Bartenders:
  • Paweł Baczyński
  • Piet Souris
  • Vijitha Kumara

I passed the Oracle Database SQL Expert Exam ( 1Z0-047 )

 
Ranch Hand
Posts: 34
1
  • Likes 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Creator of Enthuware JWS+ V6
Posts: 3306
298
Android Eclipse IDE Chrome
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Congratulations

Well done and thanks for your tips! Have a Cow!
 
Of course, I found a very beautiful couch. Definitely. And this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!