Oracle Applications Software Developer I interview questions

1. In written test, they've asked simple questions on SQL related to joins,aggregate functions,analytical functions. 2. In 2nd round, they have asked basic questions on PL/SQL and about roles of your previous project. 3. In 3rd round, they have asked to code something in the existing application. Eg: They have already have a piece of code which is incomplete, and make us to complete the program with their requried functionality.

Singelton design pattern, Deadlock,Synchronization,K size window in an array find the greatest element in each window.