Oracle Interview Question

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.