Laurent Schneider

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 !

select 1d/0 from dual;
 1D/0
-----
  Inf

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…

thanks

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)

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

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

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