As mentioned in my previous post, I participated in Oracle Certified Database SQL Expert Beta Exam. In the past weeks, Lauren Schneider, Jaffar and Jochen Van de Voorde have taken this exam.
The exam has 139 questions for 190 minutes. The areas covered both in 1Z1-047 and 1Z0-007 are easy for me because it was fresh to my memories all the things that I reviewed in preparation to the exam 1z0-007 Introduction to SQL which I have taken last August 27, 2007.
The new things that I studied are
- Performing Flashback Operation – This is really cool which allows you to trace back the previous values of the records in the table. Now, Windows is not the only one who got a Recycle bin, Oracle 10g database has it.
- External Tables
- Multitable INSERT(Unconditional, Conditional and Pivot)
- ROLLUP
- CUBE
- GROUPINGS
- WITH Clause
- Hierarchical Query
- Regular Expressions
- Advanced Queries(Correlated, Noncorrelated) – I’d been using this technique for the past years but not I have no idea that there is a term for this type of queries.
I posted a comment for this exam that they should provide a more deeper questions on Regular Expresions and Flashback operation to their exam. The questions for regular expression is too basic. For the Flashback operation, they need to cover other aspects of Flashback operations.
{ 2 comments… read them below or add one }
I see they extended the beta period, so there is hardly a chance to get a result this year! I did the RAC beta exam too, the beta period ended in June, still waiting…
I also noticed that they extended it till October 15. I posted it on Oracle Forum because I was wondering why it was extended. Is it because of the participation rate from Oracle community is too little? I hope someone of Oracle sees this post.
{ 1 trackback }