Oracle Database SQL Expert (1Z0-047) Notes…


About 7 months ago I wrote about sitting the Oracle Database SQL Expert (1Z0-047) exam. Since then I’ve been promising myself I’d write some articles about some of the sections tested by the exam. Lots of the content is pretty straight forward if you’ve been writing SQL for a few years. Also, there are lots of things that are covered in existing articles on the site.

I finally got round to writing a few posts about some of the exam content that isn’t covered, or is a bit “dispersed”, on my site.

OK, so the last one is not tested in the exam, but it should be. 🙂

With a bit of luck I’ll remember to link to these articles when people ask me questions in the future.



Author: Tim...

DBA, Developer, Author, Trainer.

7 thoughts on “Oracle Database SQL Expert (1Z0-047) Notes…”

  1. Hi.

    I totally agree (with Analytics comment, not that you are not an expert 🙂 ).

    I said when I sat the exam I was amazed analytics weren’t covered in it. Without them I would have to write some nasty SQL or use PL/SQL all the time.



  2. I know when to put them into play, but it’s usually a Google or 2 searches and then I hack my SQL together when I need it.

    Knowing about it is better than nothing I suppose!

  3. Oracle consider braindumps to be cheating. As such, if you are seen to be using braindumps, you can be disqualified from the OCP program. With that in mind, having your name on assorted blogs and forums asking for braindumps is not very clever.



Comments are closed.