I have applied online for Oracle in October-2010. I got the online written invitation with a unique invitation number for PAC test. I have given the written test in November-2010. If you write 'Software Aptitude test' in Gild.com, you can crack this easily because both are same.
In April, I got the interview call for Fusion Development Operations profile and some --Consultant position -- 7lpa.
There were 2 rounds of interviews. First is 2:1 where the 2 interviewers were in second position in Oracle and they are OK with their skills. As i am from a good premier college, they were little positive on me. Even though i messed up with the interview, as i have better offer in hand, good academic background, ..etc, I was offered.
The second is 1:1 with an higher official of Oracle. He is so cool and di not touch any tech. skills :-D. He was concentrating mainly on puzzles, aptitude, attitude,..etc. He asked me the feedback of the interview. I told him: "I dont like these interviews. They are asking same questions which can be answered by an idiot who byhearted well. Those are not testing the capability, thinking skills,..etc." I hope he was impressed with that.
Tech: they asked mainly on DBMS, OOPS, JAVA as they are my areas of interest.
This profile is not good until and unless you need money badly.
All the best for yours.