Oracle Sr Software Engineer interview questions

I had a scheduled interview. First round was fair and quick, asked me difference between String x = "abc" and String y = new String("abc"); Another scenario based question on WebServices. Cleared second round. Second round : Saw a very serious looking senior person may be ( 40+ yrs), Took my interview for 1.5hrs. Mostly on Java architecture / Middle ware / Business Modelling and scenario based question on these topics, for which I was least prepared.

I was contacted by a manager after having submitted my resume for a specific position. I spoke with him about the position and about his team. A few days later I went in for an interview. The team members seemed to be very sharp and all seemed to get along very well. I was asked specific questions in a number of one-on-one interviews about PL/SQL syntax, using PL/SQL collections, using JDBC in a Java program to iterate through a result set, various considerations when tuning a SQL database, how indexes affect execution plans of SQL, why indexing is important and how B+-tree indexes work.