Meaningless Drivel is fun!*
The moose likes Product and Other Certifications and the fly likes I have passed the Oracle Database SQL Expert Exam ( 1Z0-047 ) 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 "I have passed the Oracle Database SQL Expert Exam ( 1Z0-047 )" Watch "I have passed the Oracle Database SQL Expert Exam ( 1Z0-047 )" New topic
Author

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

ludoviko azuaje
Ranch Hand

Joined: Jun 07, 2005
Posts: 47
hello,

Yesteday I passed the Oracle Database SQL Expert Exam ( 1Z0-047 ). I scored 70 % on the exam. It was a very hard exam, I recommend a thorough preparation.

This certification is very challenging and at the same time very rewarding for the SQL insights I got from it.

The main source I used was:

OCA Oracle Database SQL Expert Exam Guide (Exam 1Z0-047) by April Wells.


Other useful material:

Oracle9i SQL Reference

Two topics I found in the exam and that are not covered in this book:

  • DEFERRABLE Clause in transactions.
  • Defining the view using the WITH CHECK OPTION clause.


  • The time is enough but do not spare much time on each question.

    I did not used any Oracle database system for practicing purposes.

    Thanks.




    SCJP 1.4, SCJP 5.0, SCWCD 1.4, Oracle SQL Expert Exam 1Z0-047
    IBM Test 255, IBM Test 730, IBM Test 142, ScrumManager® Certified.
    Will Myers
    Ranch Hand

    Joined: Aug 05, 2009
    Posts: 319

    Congratulations!

    I also took this exam last Friday and passed (just). I used OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Osborne Oracle Press Series) - Steve O'Hearn to prepare which comes with a practice test and another free one available online.

    I found the end of chapter questions very simple but the real exam is a lot harder.

    I have many years experience using SQL but on Sybase not Oracle so trying to think in Oracle's way of doing things was tough and many of the topics were new to me (Flashback, Merge, With clauses to name a few). All in all I'm glad I have done this and I have learned a great deal from it.
    Billy Tsai
    Ranch Hand

    Joined: May 23, 2003
    Posts: 1297
    I took the exam today and passed it, my study mainly focused DDL, DML, data retrieval, restricting and sorting data, functions, group data, joins, subqueries and manipulating large data sets as those areas are relevant to my job. I scored 90% for this certification exa,e
    I answers questions in the following area incorrectly:
    define subqueries, list the data types that are available for columns, replacing patterns, regular expressions, use various datetime functions.

    Is there a certification package available for having passed this exam?
    ludoviko azuaje
    Ranch Hand

    Joined: Jun 07, 2005
    Posts: 47
    Billy Tsai wrote:I took the exam today and passed it, my study mainly focused DDL, DML, data retrieval, restricting and sorting data, functions, group data, joins, subqueries and manipulating large data sets as those areas are relevant to my job. I scored 90% for this certification exan...

    Is there a certification package available for having passed this exam?


    Yes, well, that's exactly what I'm waiting for.

    Bye.
    Fazile Moser
    Greenhorn

    Joined: Apr 20, 2011
    Posts: 26
    Billy Tsai wrote:
    Is there a certification package available for having passed this exam?


    What is included in this certification package? Please describe me, I never passed an Oracle exam.
    ludoviko azuaje
    Ranch Hand

    Joined: Jun 07, 2005
    Posts: 47
    Hello,

    In the certification package you get a member card, a printed certificate, a welcome letter with instructions to download the logo and to open an oracle account for certified members.

    bye.

    Sudarshan Sreenivasan
    Ranch Hand

    Joined: Jun 28, 2007
    Posts: 188

    If you took the exam in india can you tell me how much the exam voucher costed you ?
    Mahtab Alam
    Ranch Hand

    Joined: Mar 28, 2012
    Posts: 222

    I just have passed my ocp6 exam , i am looking to get one database exam
    .I found 1z0-047 .
    can you tell is this is what to go for

    Oracle Java Programmer , Oracle SQL Expert
    James X Peterson
    Whizlabs Java Support
    Ranch Hand

    Joined: Feb 26, 2013
    Posts: 158

    congratulations for your success of getting certified 1Z0-047
    Kumar Khiani
    Ranch Hand

    Joined: Aug 24, 2013
    Posts: 40

    Hi guys,

    Congratulations to all for clearing this exam.

    I am a complete newbie to databases, and i am aiming to clear this exam.

    Is there any good mock test softwares available to practice (like Enthuware).

    Transcender costs whooping $100+. Is it worth it? Are there any other mock tests available at reasonable price.

    Enthuware helped me a lot to learn all the corner cases in Java at reasonable costs.

    Thanks for your guidance in advance.

    Regards,

    Oracle Certified SQL Expert
    OCEWCD 6, OCPJP 7, OCAJP 7
    Stefan Feldmann
    Ranch Hand

    Joined: Nov 07, 2013
    Posts: 38
    I didn't use Transcender for preparation. I recommend you after studying Oracle Press guide to buy Matthew Morris summary guide http://www.oraclecertificationprep.com. His guide is very good help for exam.
    Kumar Khiani
    Ranch Hand

    Joined: Aug 24, 2013
    Posts: 40

    Thanks Stefan for your prompt reply.

    Will get Matthew Morris summary guide as well.

    This solves my query. It seems there are no reasonable mock-test providers for this test.

    Thanks,
    Kumar.
    Mahtab Alam
    Ranch Hand

    Joined: Mar 28, 2012
    Posts: 222

    I studied steve o'Hearn book.
    And scored 76% in the exam that comes in CD , Then I worked on points where I was weak.
    And then took the same test this time I scored 96%.

    After that I took one online test from databasetrainingdotcom that is based on 1z0-047 exam.I scored 81%.

    Is I am ready to take the real exam.

    And what are the key topics to pass this exam
     
    It is sorta covered in the JavaRanch Style Guide.
     
    subject: I have passed the Oracle Database SQL Expert Exam ( 1Z0-047 )
     
    Similar Threads
    Oracle Sql certification
    SQL certification query
    About Oracle Certification
    Java Developer ... LPIC or OCA/OCE
    Oracle certs for Java developers - any advice ?