I am now Oracle Database SQL Expert for Oracle Database 11g

I am very glad to inform that I have just passed Oracle Database SQL Expert (1Z0-047) exam with 100% score.

I took the exam today (20-Nov,2009) at 11:00 AM at Caliber Technocrats, a Pearson VUE in Vizag.

So, I have added one more certification to existing list of Java Certifications:

Sun Certified Java Programmer
Sun Certified Web Component Developer
Sun Certified Business Component Developer

Exam Content

Oracle Database SQL Expert is an exam that tests your skills of SQL in Oracle. The following are the areas that it tests.

Creating database object
Standard Functions
Queries – grouping, join and sub queries
DML and transactions
Views, indexes, sequences
Merge, multi-table insert, external table
Regular expressions
Timestamp, Interval data types and time zone

The exam contains 70 questions and you have 120 min. You have to get 66% to pass.

My Preparation

I used Oracle Database 11g SQL by Jason Price, Oracle Documentation and Oracle SQL Course Material I and II.

I went through whatever questions I could get from internet. Understand not the answer for the question, but understanding why the answer is right or wrong is very important. After all, the exam was not about remembering things but knowing things.

Score Sheet

The score sheet doesn’t contain any details but the score 100%. It would give details of questions that are answered incorrectly, but fortunately I don’t have anything in that area.

Here is my Score Sheet.