My manager is based in the UK, so my interview was telephonic. Two members conducted the telephonic interview. It was not very hard, and I was able to answer most of the questions.

I was selected after the single telephonic interview, which is rather surprising as Oracle tends to conduct multiple interview rounds.

How do COMMIT and ROLLBACK work under the hood?

How do you handle a situation when you have a lot to finish and are sure to miss the deadline?

What are the various Perl modules you developed? Which was the most complex or useful?

What do you give maximum importance to while writing code?

How do you optimize an INSERT query where you need to insert millions of rows of data very frequently?