Oracle Application Developer Interview experience (YOE:3)

I interviewed for an Application Developer position at Oracle in September . I had applied through multiple job sites and received a call from a recruiter in the Oracle Fusion apps department. The interview process consisted of three rounds: a coding round, a second coding round, and a managerial round.

In the first coding round, I was asked to solve the following questions:

1. 2 Sum problem (working code)
2. Find Intersection of a linked list (Algo)
3. All permutations of a string. (working code)

In the second coding round, I was asked to solve the following questions:

1. Search an element in Rotated and Sorted Matrix 2. (working code)
2. Combination Sum 2. (working code)

The managerial round started with a discussion of my past projects. This was followed by some behavioral questions and a final database schema design for Inventory Management. I was also asked to write a few queries, such as a query to extract the product with the highest sales.

I did not perform well on the queries portion of the interview, but I did well on the other questions in all rounds. I was selected for the position but ultimately declined the offer because I received a better offer later.