• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 150
1
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.


     
    Ranch Hand
    Posts: 462
    Scala jQuery Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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.
     
    Ranch Hand
    Posts: 1327
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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
    Posts: 150
    1
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    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.
     
    Greenhorn
    Posts: 26
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    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
    Posts: 150
    1
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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.

     
    Ranch Hand
    Posts: 188
    IntelliJ IDE MySQL Database Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    If you took the exam in india can you tell me how much the exam voucher costed you ?
     
    Ranch Hand
    Posts: 391
    1
    MySQL Database PHP Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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
     
    Whizlabs Java Support
    Posts: 158
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    congratulations for your success of getting certified 1Z0-047
     
    Ranch Hand
    Posts: 40
    Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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,
     
    Ranch Hand
    Posts: 75
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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
    Posts: 40
    Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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
    Posts: 391
    1
    MySQL Database PHP Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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
     
    Greenhorn
    Posts: 7
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    I have completed 1Z0-047 with 100%. It was validated against 11gR2 and 12C.
     
    Bartender
    Posts: 2661
    19
    Netbeans IDE C++ Linux
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Congratulations, Vamsi!
     
    Vamsi Myalapalli
    Greenhorn
    Posts: 7
    • Likes 1
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Thanks a lot Jan Cumps. All the Best
     
    Greenhorn
    Posts: 2
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Hi. i am newbie and want to prepare for  1Z0-047 exam.
    Gurus: Could any one send me 1Z0-047 exam preparation material at my email mwaseem830@gmail.com e.g. books notes
    I would be thankful.
     
    Ranch Hand
    Posts: 207
    3
    Oracle MySQL Database Java
    • Likes 1
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    @Muhammad waseem first of all I wanted to tell you that 047 exam is retired now. That's how unfortunate for the Database Lovers(like me   lol:) ). But no problem it is not the end of the Database. Because 047 is now retired so Oracle also provided the replacement for it which is 1Z0-071 exam(Oracle Database SQL Certified Associate). I am also just starting to prepare for it. You can take that exam.
     
    Muhammad waseem
    Greenhorn
    Posts: 2
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    @ O Shea thanks for your reply.
    and thanks  for updating me. I was preparing for that...
    If you have updated material for 1Z0-071 then please send me at mwaseem830@gmail.com i will thankful for this.
     
    O Shea
    Ranch Hand
    Posts: 207
    3
    Oracle MySQL Database Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    I have created a whatsapp group you can join this=>

    https://chat.whatsapp.com/BTMszm00dgi2aelL1HFJR5
     
    reply
      Bookmark Topic Watch Topic
    • New Topic