Oracle Certified SQL Expert
July 10th, 2007
Oracle Certification Program: Exam Details
I immediately registered for this exam and will do it next week, I just cannot wait for this one…
Categories
- 11g
- 11gR2
- Add new tag
- Application Server
- blog
- Blogroll
- book
- browser
- certification
- content database
- cygwin
- data modeling
- dba
- event
- forums
- fun
- game
- installation
- java
- ldap
- license
- linux
- news
- OEM
- oid
- openworld07
- orablog-tag
- ovid
- personal
- plsql
- RAC
- rman
- security
- Solaris
- sql
- sql developer
- sqlplus
- Streams
- support
- TimesTen
- toad
- Uncategorized
- unicode
- unix
- vista
- windows
- xml
Archives
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
- June 2005
- May 2005
Hi Laurent,
>> I just cannot wait for this one…
You love taking tests, don’t you!
What do you think about people who have zero real-world experience, running about claiming that they are “Oracle Certified Experts”?
What happens when an Oracle Certified Expert crashes a mission-critical database? Is Oracle at-fault for “expertizing” them?
Tests are fine and tests are fun, but passing a test, any test, doesn’t make someone a true expert, IMHO.
This wil be interesting. I’ve seen lots of Oracle certified idiots . . . Hopefully, this test will be rigorous enough to be meaningful . . .
Even non-experts could attend this test, for sure, and the experts should have no problem list[ing] the capabilities of SQL SELECT statements and Execut[ing] a basic SELECT statement
Let’s hope there are some creative questions in the test !
they should put this into exam
Q: can oracle divide by zero?
A: no
Q: are you absolutely sure?
A: yes
Q: then why does this work?
select 1 from dual where exists (select 1/0 from dual)
A: ????
Let me guess - A two day guide again
Marco, I will rather read the 10gR2 SQL Reference this time, but not the DBA staff (like tablespace, management, audit). Well, I have no idea what version I should use to do the exam, probably the 10gR1, but I think 10gR2 is old enough…
Laurent,
Best of Luck…
waiting for the part
Sidhu
party*
thanks
I noticed you started a book, congratulations! Book authoring is superior certification:-)
Well, I also read about the SQL OCE exam… Yes, the RAC and Linux OCE exams are fine (I attended the RAC beta, btw.), but I don’t see much point at the SQL exam, at least for people on this level of expertise (OCM, …).
But definitely, I’m looking forward for your comments regarding the diffculty of the exam etc.
I hope I will have less mistakes than the documentation…
The last I found :
Some valid user-defined function expressions are:
hr.employees.comm_pct(dependents, empno)@remote
Instead of
hr.employees.comm_pct@remote(dependents, empno)
“I hope I will have less mistakes than the documentation…”
Thats humour
Have fun on the test Laurent.
Hi Laurent
You prepare yourself to render “SQL Expert” with the manual
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm
only?
Regards
Hector Gabriel Ulloa Ligarius
http://ligarius.wordpress.com
yes, actually, I am a bit worried about external table access drivers so I read that too :
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/part_et.htm
Thank you for reply
You would like to travel to Chile and to dictate some class of oracle?
It is necessary to dream…..
See you Laurent
Regards
Hector Gabriel Ulloa Ligarius
http://ligarius.wordpress.com
Hi,
The question posted by Erik’s is really cool. I am gonna discuss it on my blog.
Why does this work?
select 1 from dual where exists (select 1/0 from dual)
Regards
this is because it is optimized
select 1 from dual where exists (select expression from dual)
expression is never evaluated
the result on 2test.com is updated. I passed
Congratulations! Welcome to the OCE world.
thanks! I received my test report.
90%. You may want to review the following objectives :
- Add Constraints
- Drop columns and set columns unused
- User the following types of multitable inserts (nothing follows…)
- Regular Expression Functions
- Updates rows in a table
- Control Transaction
Well, when trying a add constraint or drop column, I quite frequently looks in the doc for some advanced syntax. The multitable inserts were quite confuse. Update rows in a table? well, what’s that? Control Transaction? Did I miss something with savepoint or so?
But I must comment about regexp. The questions were miserable. Out of five questions, only one was correctly asked. The question authors would probably get something like 26% if I were asking the questions (this is only 1% more than pure random). I wrote the comments but it apparently did not help.
Anyway, this is the risk with beta exam
@Ligarius
EXISTS is a logical test for the return of rows from a query, not for the rows themselves.
Hi Laurent,
I want to prepare for 1Z0-047 Oracle Database SQL Expert examination. Can you please let me know the books I need to prepare and if any links to download them for free?
Thank You,
Shyam.
Free books? Well, the online doc is free ! go to http://docs.oracle.com
About some “exam cram”, go to your favorite bookshop and search for 1z0-047.
My own book cover all what you need regarding joins, subqueries, functions. But it does not cover all the exam content.
Cheers,
Laurent
Hi Laurent,
I need some help… I plan to give the SQL Expert exam. I have around an year’s experience in MySQL but that too not deep enough. Can you please tell me what is the amount of time in which I can prepare for the SQL Expert exam considering I can dedicate almost all of my time to it for the next couple of months?
Also, I’ll use the reference documentation for prep, but what else needs to be done for being ‘exam centric’? Is there any kind of question bank or such stuff that you can point me to?
Thanks a lot…
Hi,
Maybe that won’t be popular advice here but you can try looking for 1z0-047 preparation pdf’s on torrent site’s.
I’ve seen some stuff there but since my company has skillport CBT’s I am using these to prepare.
Other option is to look for example questions more official way- even if those are commercial you can always download demo with 15 questions or such.
Amount of time? It’s hard to say, I mostly did get my sql skills in work. I don’t think I would be enough motivated if I wouldn’t use most of this in my every day activities.
Mmirsk,
You may prefer getting free certification questions to train rather than paying 99$ to self test software, but it is not popular as it degrades the value of certification…
If you can get exam question on torrent and pass it with zero experience, it is no glory
The certification blog contains multiple posts about cheating, you may want to have a look.
PS: imho, if you pay 99$ on selftestsoftware and pass the expert exam with no experience, it is still degrading the value of certification, ymmv
Hi Laurent,
Thanks for the reply… I agree with you. As the official prep book for SQL Expert is not yet out, I was thinking of completing the ground work from the SQL Fundamentals I and II books. How would you recommend that? Is the depth in which the matter is covered good enough? Also, is the difficulty level in those books at par with the actual SQL Expert exam?
I do not know those two books, sorry…