The selection process is mostly driven by the hiring team itself.
Questions asked cover data structures and algorithms, SQL queries, and Java concepts. Average knowledge in these areas would suffice; it's not too hard.
Merge two sorted arrays.
Some SQL queries around GROUP BY and HAVING.
The following metrics were computed from 220 interview experiences for the Oracle Applications Developer role in India.
Oracle's interview process for their Applications Developer roles in India is fairly selective, failing a large portion of engineers who go through it.
Candidates reported having very good feelings for Oracle's Applications Developer interview process in India.