aspose file tools*
The moose likes Product and Other Certifications and the fly likes 1z0-047 : Oracle Database SQL Certified Expert Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Certification » Product and Other Certifications
Bookmark "1z0-047 : Oracle Database SQL Certified Expert" Watch "1z0-047 : Oracle Database SQL Certified Expert" New topic
Author

1z0-047 : Oracle Database SQL Certified Expert

Kumar Khiani
Ranch Hand

Joined: Aug 24, 2013
Posts: 40

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

Regards,
Kumar




Oracle Certified SQL Expert
OCEWCD 6, OCPJP 7, OCAJP 7
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30973
    
159

I've moved this to our "other certifications" forum. Searching this forum for the exam number gives some suggestions such as this one.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Kumar Khiani
Ranch Hand

Joined: Aug 24, 2013
Posts: 40

Thanks Jeanne.
Stefan Feldmann
Ranch Hand

Joined: Nov 07, 2013
Posts: 43
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)
Will Guise
Greenhorn

Joined: Oct 13, 2014
Posts: 1
Hi,

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.



 
 
subject: 1z0-047 : Oracle Database SQL Certified Expert