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…
Oracle Certification Program: Exam Details
I immediately registered for this exam and will do it next week, I just cannot wait for this one…
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