Oracle Senior Consultant interview questions

Interview is on Oracle SQL and PL/SQL technical from basic to advanced. Some questions on JAVA. Many question on current roles and responsibilities. Asked about basic bank transaction questions. Asked to explain about Performance Tuning.

Interview process was nightmare. but the actual interview was not hard at all. I was interviewed in January 2011. There was three round of interview. first round with team lead or project senior. then the next with project manager. the final round was with HR. All the interviews were conducted on the same day. in about a weeks time i was informed that i was selected and was asked to submit all the documents. and then there was no communication at all for next 6 months. Finally OFSS HR called back in August 2011 and asked me to attend one more round of telephonic interview with Project manager. finally in September 2011 i received my offer letter.