You have to be more concise in explaining to the interviewer as well as study the concepts based on the job description. Make sure you confident and be always make a positive vibe in your interview
It had three levels : technical interview, hr + technical interview and hr interview. Technical interview asked about domain knowledge and SQL queries and some puzzle questions. Hr+ technical asked about the project and whole about resume. And last round was just the confirmation round and was asked about relocation
I got into Oracle by Campus placement. There were 3 rounds of technical interviews. In each round i was asked technical and behavioral questions. Technical questions were related to data structures and algorithms.