• 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 ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

1z0-047 : Oracle Database SQL Certified Expert

Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi There,

Mods, I am not sure if this is the right forum to ask about SQL certification exam.

I just cleared OCEWCD and now I want to prepare for 1z0-047 : http://www.oraclecertificationprep.com/apex/f?p=OCPSG:EXAM_DETAILS:0::NO::P2_EXAM:1Z0-047#.UrnJyNIsLgE

For all Java Certifications it was very easy to get the guidance on how to go about getting any Java Certificate, but for SQL Expert I cannot find any proper guidance. Would appreciate if any one can help on the following

1) Best Book to refer
a) Study Guide for 1Z0-047: Oracle Database SQL Expert: Oracle Certification Prep by Mathew Morris OR
b) OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (With CD-ROM) 1st Edition by Steve O'Hearn http://www.flipkart.com/oca-oracle-database-sql-certified-expert-exam-guide-exam-1z0-047-with-cd-rom-1st/p/itmczynwjy6r6fhy?pid=9780070701410&otracker=from-search&srno=t_1&query=047&ref=2eb9bcb6-2e60-4ae8-b82d-67aec740e5c4
c) Or is there any other book to refer from

2) Best Mock Test Software
Which is the best mock test software available for this Exam. (Enthuware made preparation for all the Java exams feel like a breeze)

3) Forum
Is there any other forum as good as this one, which discusses about SQL certification experiences and related question/answers.

Thanks in advance for your feedback


author & internet detective
Posts: 40198
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've moved this to our "other certifications" forum. Searching this forum for the exam number gives some suggestions such as this one.
Kumar Khiani
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jeanne.
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Kumar

I recomment you Steve O'Hearn book. It's a full study guide. When you are "ready" for exam, read Mathew Morris summary study guide.
I didn't use any Mock Test software. But Oracle recommends something on their exam page.

I recommend you OraFAQ: SQL division http://www.orafaq.com/forum/f/1/ and training section http://www.orafaq.com/forum/f/35/0/
Oracle hosts also a community (OTN network)
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Just took this exam today and passed it with a 74% - the euphoria of seeing a passing grade on the Oracle site is only gradually wearing off!

I took it upon myself to learn Oracle SQL myself without classroom instruction, using mostly the textbook Oracle SQL by Example 4th Edition by Alice Rischert. I also had a few other SQL books, but this was my main source material. From there, I downloaded SQL Developer and did months of hands-on self-training.

For 2 months leading up to my exam date, I did practice exams and an online learning guide through Kaplan, a pay-for-usage site approved by Oracle. These practice exams do a great job of mimicking the real exam, so I found the rental price definitely worth it.

I must admit - the exam is a beast. 66% as a passing grade seems easy enough with an exam length of 2 hours, but considering 75 questions with a different "scenario" for each....it's a challenge and you need to know your stuff without spending much time on each question.

Many questions have an "exhibit" button which will show you a table(s) pertaining to the question; others actually show you an actual mock schema with multiple tables. I found that viewing the exhibits only slows you down and many questions can be answered just by understanding what the scenario of the question is telling you. Again, time is of the essence.

As for what I encountered in the exam:

Quite a few select statement and DML-related questions. Most of these require pointing being able to view correct syntax in a short amount of time. Honestly, I think you need to get the bulk of these questions correct since it only gets harder.

A LOT of questions regarding indexes and views; you really need to know both inside and out and just not how to create them. There were a few of those dreaded "Which 4 of the following 6 statement regarding indexes is correct?" questions. DML rules when it comes to views is a subject touched on multiple times.

Several questions regarding hierarchical queries.

I was surprised how advanced reporting options like dense_rank and the over clause w/ group functions never made an appearance. I think there was one question regarding the "with" clause.

Not as many questions about DCL and object/ system privileges as I expected.

The "order by" clause is relevant to many questions too, particularly its different options and used with set operators.

External/index-organized tables made a few appearances; much like indexes/views, both of these topics were ones that were not heavily featured in my study guide and which I felt I still had some things to learn after taking this exam.

Overall, it's a tough exam that will challenge your thorough knowledge of SQL, but use what you know to eliminate wrong answers and have a sharp eye for syntax detail.

Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic