I applied through university. The process took 1 day. I interviewed at Oracle (San Francisco, CA) in Nov 2008
Interview
Was contacted directly via email that Oracle wanted to interview me on-site. They claimed they found my CV through the school's database. They were very generous and hospitable throughout the stay: they flew me in on a Wednesday evening, had a rental car waiting, and put me to sleep in a nice hotel. Thursday was interviews all day long, one after the other (6 total, each about 1 - 1.5 hours long). Many consisted of IQ questions (puzzle solving), but there were also personality tests and skills tests. Specifically, they grilled me on Java knowledge (keywords, syntax, and example problems). The interviews were all independent of each other: each interview was really a smaller group within Oracle that wanted to interview me their own way. They let me stay in SF all of Friday, and I flew home on Saturday morning.
5 horses on a 5-lane track. You have 5 horses and you want to rank the top three. All you have available to you is a track and the ability to tell perfectly in which order the horses crossed the finish line. How many races are necessary in order to rank the top three horses?
Mostly coding question focused, and some talking about personal experience and terms. Some technical design, you could have chosen any language to complete the coding questions. Questions were simple technical concepts that person came up with at the moment.
Interview questions [1]
Question 1
Something like searching in logs using maps and filter/find data
decent amount of DSA and System design were asked, and behavioral questions. so prepare leetcode level questions and good amount knowledge in sql, java and also mostly oracle sql. overall it was good
First online assessment. Then 2 interview rounds + 1 hr round. This was during campus placement. In interviews they mainly asked about dsa, os concepts, logical questions and some system design questions also.